Get JSON from previous step in Pipeline for 2nd API call to external source

Dana
are you using the step called Fetch JSON?  Do not an API call but Fetch JSON

And then you paste in the API response into the sample code area and it should create a panel of fields for you to drag into a subsequent step.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

@Dana Hauser

First, you'll need to convert the content returned from your API into something you can work with in jinja2.

When you use the Make a Request step from the Webhooks channel, one of the variables returned should be "Content".

You can convert that content into something usable by creating a new variable, and then applying the from_json filter.

{% set json_content=a.content | from_json %}
after you have converted the content from json, you can access the properties in the same way you would any other variable using jinja2 in Pipelines. For your purposes it would probably look like this:

{% set json_content=a.content | from_json %}
{{json_content.data[0].corelogicPropertyId}}

If you don't have to use OAuth authentication to access the API, I would recommend using the JSON Handler channel instead. It will make it a lot easier to work with the data, especially if need work with a response containing more than one record.

------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------