Skip to main content
Question

To capture an XML response from an API in Pipelines

  • May 12, 2022
  • 0 replies
  • 563 views

LaszloM
Forum|alt.badge.img+1
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img
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
------------------------------