Discussions

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

    Posted 13 days ago
    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 5 days ago
    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
    ------------------------------