Forum Discussion

LaszloM's avatar
LaszloM
Qrew Trainee
3 years ago

To capture an XML response from an API in Pipelines

Hi All,   I would like to use a simple Quickbase API (API_ProvisionUser) in a Pipeline and use the  user id included in the response in my subsequent Pipeline steps. Response promised in the API do...
Pipelines
PhillipDennis's avatar
PhillipDennis
Qrew Cadet
Hi Laszlo. It's not very well documented, but the Quickbase API channel actually returns a JSON object that you can easily access with Jinja if you know how. If you make the call in step A of your pipeline, for example, you can access the result with {{a.json.qdbapi.value}}. Give that a try.

PHILLIP DENNIS
Principal | Watkyn LLC
Quickbase Partner
(954) 900-6690 | hello@watkyn.com
www.watkyn.com
Watkyn LLC

------------------------------
Phillip Dennis
------------------------------
DamonWalls's avatar
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's avatar
    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's avatar
      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
      ------------------------------