Forum Discussion

DanaHauser's avatar
DanaHauser
Qrew Cadet
4 years ago

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

Hi, I'm looking for some help with a pipeline.  I've created step A which sends an api call for a MLS property search.  This first step I used the Make a Request function under webhooks.  It gets a...
Pipelines
JustinTorrence's avatar
JustinTorrence
Qrew Cadet
4 years ago


I think this is what will end up going in your URL field:

{% set json_content=a.content | from_json %}
https://property.corelogicapi.com/v2/properties/{{json_content.data[0].corelogicPropertyId}}/ownership

Basically, after you set your variable, you just replace <clip> with the template that returns the property id:

{{json_content.data[0].corelogicPropertyId}}



------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------
DanaHauser's avatar
DanaHauser
Qrew Cadet
4 years ago
@Justin Torrence

Do you know how the Jinja would be for extraction the CLIP from the JSON below?



I'm almost there.

Thanks


------------------------------
Dana Hauser
------------------------------
  • JustinTorrence's avatar
    JustinTorrence
    Qrew Cadet
    4 years ago
    I would imagine it's something like this (assuming there is only ever one object in "items"

    Also it is unclear what variable you are showing the output for, but I will assume that it is "a".

    {{a.json.items[0].clip}}

    ------------------------------
    Justin Torrence
    Quickbase Expert, Jaybird Technologies
    jtorrence@jaybirdtechnologies.com
    https://www.jaybirdtechnologies.com/#community-post
    ------------------------------
    • DanaHauser's avatar
      DanaHauser
      Qrew Cadet
      4 years ago
      It's the a: variable, I tried everything I could think of, but nothing works.  I'm defeated.  :-(

      ------------------------------
      Dana Hauser
      ------------------------------
    • DanaHauser's avatar
      DanaHauser
      Qrew Cadet
      4 years ago
      @Justin Torrence

      I just received a response from QB help on this, no luck there either.  I guess it simply can't be done. Seems like it should, but I guess not.

      Thanks for trying, I appreciate your attempts.  I'll send you a little gift of appreciation.

      Have a great weekend,

      Dana

      ------------------------------
      Dana Hauser
      ------------------------------