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
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
      ------------------------------