Forum Discussion

PhillipDennis's avatar
PhillipDennis
Qrew Cadet
4 years ago

Re: To capture an XML response from an API in Pipelines

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
------------------------------

11 Replies

  • LaszloM's avatar
    LaszloM
    Qrew Trainee
    4 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's avatar
      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's avatar
    MalcolmMcDonald
    Qrew Cadet
    4 years ago
    This is a gift -- thank you Phillip!

    ------------------------------
    Malcolm McDonald
    ------------------------------
  • DamonWalls's avatar
    DamonWalls
    Qrew Member
    4 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
      4 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
        4 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
        ------------------------------