Discussions

 View Only
  • 1.  To capture an XML response from an API in Pipelines

    Posted 05-12-2022 17:04
    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 docs:
    <?xml version="1.0" ?>
    <qdbapi>
       <action>api_provisionuser</action>
       <errcode>0</errcode>
       <errtext>No error</errtext>
       <userid>112248.5nzg</userid>
    </qdbapi>
       Is there a way I can parametrize a Quickbase channel API request to get the XML response? Suppose getting my stuff out of the XML text would be somehow possible, but how can I capture the API response? Seems Pipelines does not offer any available new field after establishing this API request step. Or I am doing something wrong...
       Thank You!

    ------------------------------
    Laszlo M
    ------------------------------


  • 2.  RE: To capture an XML response from an API in Pipelines

    Posted 05-20-2022 10:35
    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


    ------------------------------
    Phillip Dennis
    ------------------------------



  • 3.  RE: To capture an XML response from an API in Pipelines

    Posted 24 days 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
    ------------------------------