Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
4 years ago

Pipeline Trigger : Incoming JSON ,how to extract from body_json

Hellos, I've a simple JSON file but I'm unable to extract the value below body_json.contact.displayName fails body_json.contact.displayName.0 fails body_json:Object contact.displayName:...
Pipelines
SSNJeffP's avatar
SSNJeffP
Qrew Captain
4 years ago
Which pipeline steps are you using?

You should have something like:

A.  Incoming Request or Make Request
B.  Iterate over JSON records - In this step you need to put a sample of the JSON in the 'JSON Schema Sample' area.   Once you do this,  you should be able to access the values from the request in later steps.

------------------------------
Jeff Peterson
------------------------------
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
4 years ago
HI Jeff,

Thanks for the reply . 

I was approaching JSON like web hook and was only checking on Incoming Request. 

my JSON Schema is failing in iteration , I've asked developer to update me on this. 

PS : I would love to see some example of JSON you've got working , I can get on a zoom as well if you get time.
----



body_json:Object
channelId:Array[1]
0:"51de5162-1679-4313-b068-b7553227beea"
contact.customDetails.custom1:Array[1]
0:""
contact.customDetails.custom2:Array[1]
0:""
contact.customDetails.custom3:Array[1]
0:""
contact.customDetails.custom4:Array[1]
0:""
contact.displayName:Array[1]
0:"Prashant Maheshwari"
contact.email:Array[1]
0:""
contact.firstName:Array[1]
0:"Prashant"
contact.href:Array[1]
0:"https://contacts.messagebird.com/v2/contacts/12e2473fdc244b908a79292475ca08f4"






------------------------------
Prashant Maheshwari
------------------------------
  • SSNJeffP's avatar
    SSNJeffP
    Qrew Captain
    4 years ago

    I'm guessing your JSON schema isn't a valid JSON.  

    Mine looks like this:



    ------------------------------
    Jeff Peterson
    ------------------------------
    • PrashantMaheshw's avatar
      PrashantMaheshw
      Qrew Captain
      4 years ago
      Thanks Jeff,

      This will help me talk to developer

      ------------------------------
      Prashant Maheshwari
      ------------------------------
      • PrashantMaheshw's avatar
        PrashantMaheshw
        Qrew Captain
        4 years ago
        Hey Jeff,
        I talked to my developer and we managed to get it working with below. 

        {{a.body_json["contact.displayName"][0]}}

        I'm so surprised , so much of pipeline JINJA is hidden from us and undocumented

        ------------------------------
        Prashant Maheshwari
        ------------------------------