Forum Discussion

DanaHauser's avatar
DanaHauser
Qrew Cadet
3 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
DanaHauser's avatar
DanaHauser
Qrew Cadet
Hi Justin,

Thanks for your reply.  I'll try your suggestion and see what happens.  I didn't use the Fetch JSON due to the OATH 2.0 I needed right off the bat.  I explained it a little more in my reply to Mark below. 

Thanks,

Dana

------------------------------
Dana Hauser
------------------------------
DanaHauser's avatar
DanaHauser
Qrew Cadet
3 years ago
Justin,

This makes total sense, but I'm not exactly sure where to put the jinja2 code?
{% set json_content=a.content | from_json %}
{{json_content.data[0].corelogicPropertyId}}

Thanks again,

Dana

------------------------------
Dana Hauser
------------------------------
  • JustinTorrence's avatar
    JustinTorrence
    Qrew Cadet
    3 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
      3 years ago
      Hi Justin,

      That is what I need, but I made an error in the original call, which does have the clip line in it.  What you suggested worked, except I need the clip not the other id.

      How would I pull the clip, which appears to be an object I'm guessing.  

      Here's the part of the response that has the clip:

      Pragma:"no-cache"

      Cache-Control:"no-cache, no-store, max-age=0, must-revalidate"

      Date:"Tue, 05 Apr 2022 23:23:56 GMT"

      X-Iinfo:"12-76855587-76855601 NNYN CT(10 23 0) RT(1649201036020 107) q(0 0 0 0) r(1 1) U16"

      X-Frame-Options:"DENY"

      Content-Type:"application/json"

      Expires:"0"

      json:Object

      items:Array[1]

      0:Object

      propertyAddress:Object{city:DEWEY, state:AZ, streetAddress:831 N OLD CHISHOLM TRL, zipCode:86327, county:YAVAPAI…}

      propertyAPN:Object{universalParcelId:48722900, apnParcelNumberUnformatted:40216104, apnSequenceNumber:1, previousApnUnformatted:null, apnParcelNumberFormatted:402-16-104…}

      clip:"4903742157"  ******* I NEED THIS DATA HERE *******

      v1PropertyId:"04025:48722900"

      messages:Array[0]

      metadata:Object

      totalRecords:1

      totalPages:1

      pageNumber:1

      pageSize:1

      I'm so close.  Thank you again.

      ------------------------------
      Dana Hauser
      ------------------------------
    • DanaHauser's avatar
      DanaHauser
      Qrew Cadet
      3 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
        3 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
        ------------------------------