To capture an XML response from an API in Pipelines

LaszloM
Qrew Trainee
3 years ago
Thank You Phillip!

That opened the door and now I'm down the rabbit hole into JSON parsing and JINJA filters....
I asked for it, I know...

Thank you so much, just that little piece was what I needed!

------------------------------
Laszlo M
------------------------------
- Hongkunliang
  Qrew Cadet
  2 years ago
  Hi Laszlo, I have the same situation. Do you mind to share your code how to get the user id? Much appreciated!
  
  Best regards,
  
  Hongkun
  
  ------------------------------
  Hongkun liang
  ------------------------------
MalcolmMcDonald
Qrew Cadet
3 years ago
This is a gift -- thank you Phillip!

------------------------------
Malcolm McDonald
------------------------------
DamonWalls
Qrew Member
3 years ago
What would channel/step would come after the Quickbase Make Request channel step that would accept the {{a.json.qdbapi.value}} response?

------------------------------
Damon Walls
------------------------------
- MalcolmMcDonald
  Qrew Cadet
  3 years ago
  For my use, I did another make request as the second request depended on the the result of the first.
  
  https://xxx.quickbase.com/db/xxx?a=API_SendInvitation&userid={{b.json.qdbapi.userid}}&usertext="Welcome."
  
  I can definitely see use cases where you would want to create a record to store the request and result, or update a record with new information etc.
  
  ------------------------------
  Malcolm McDonald
  ------------------------------
  - DamonWalls
    Qrew Member
    3 years ago
    Thank. I'm looking to make a second as well depending on the result of the first. I'm making a GetUserRole call and need to check the response to see if the user is in specific roles already, if not make another request call to AddUserToRole.
    
    Anyone have any insight on how the expression should look to check the response via {{b.json.qdbapi.value}}? Definitely a Jinja newbie.
    
    ------------------------------
    Damon Walls
    ------------------------------
PrashantMaheshw
Qrew Captain
2 years ago
Huge shout out to Phillip for discovering and posting this. It was a major lifesaver for me to find the RecordID of the item I just created using QuickBase MAKE REQUEST step in pipeline

------------------------------
Prashant Maheshwari
------------------------------
- Hongkunliang
  Qrew Cadet
  2 years ago
  Hi Prashant, I have the similar case as yours. I am using the Make Request to call API "CopyMasterDetail", I'd like to get the parentRid. Should I directly use the b.json.qdbapi.parentrid or parsing the b.content? Thanks in advance!
  
  ------------------------------
  Hongkun liang
  ------------------------------
  - PrashantMaheshw
    Qrew Captain
    2 years ago
    you can capture the response at https://jsonpathfinder.com/ and find the exact path of the item.
    
    In my case the value was found at {{b.json["metadata"]["createdRecordIds"][0]}}
    
    b represents the step and id was was what QuickBase created.
    
    ------------------------------
    Prashant Maheshwari
    ------------------------------
DonLarson
Qrew Elite
7 months ago
Phillip,
I am trying to solve a similar issue. I am making a Post with the REST API and want to get the RID back for the created record. The documentation for the new API
https://developer.quickbase.com/operation/upsert
shows the RIDs are in a section
"metadata": { "createdRecordIds": [ 11, 12 ], "totalNumberOfRecordsProcessed": 3, "unchangedRecordIds": [], "updatedRecordIds": [ 1 ]
I have been playing with the syntax to get the createdRecordIds and am struggling to get there. Can you share an example on extracting it?

Forum Discussion

To capture an XML response from an API in Pipelines