Pipeline Trigger : Incoming JSON ,how to extract from body_json

Question

Hellos,I've a simple JSON file but I'm unable to extract the value belowbody_json.contact.displayName failsbody_json.contact.displayName.0 failsbody_json:Objectcontact.displayName:Array[1]0:"Prashant Maheshwari"------------------------------Prashant Maheshwari------------------------------

jeffpeterson1 · Answer

I'm guessing your JSON schema isn't a valid JSON.&nbsp;&nbsp;Mine looks like this:
------------------------------Jeff Peterson------------------------------

jeffpeterson1 · Answer

Which pipeline steps are you using?You should have something like:A.&nbsp; Incoming Request or Make RequestB.&nbsp; Iterate over JSON records - In this step you need to put a sample of the JSON in the 'JSON Schema Sample' area.&nbsp; &nbsp;Once you do this,&nbsp; you should be able to access the values from the request in later steps.------------------------------Jeff Peterson------------------------------

prashantmaheshw · Answer

HI Jeff,Thanks for the reply .&nbsp;I was approaching JSON like web hook and was only checking on Incoming Request.&nbsp;my JSON Schema is failing in iteration , I've asked developer to update me on this.&nbsp;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------------------------------

prashantmaheshw · Answer

Thanks Jeff,This will help me talk to developer------------------------------Prashant Maheshwari------------------------------

prashantmaheshw · Answer

Hey Jeff,I talked to my developer and we managed to get it working with below.&nbsp;{{a.body_json["contact.displayName"][0]}}I'm so surprised , so much of pipeline JINJA is hidden from us and undocumented------------------------------Prashant Maheshwari------------------------------

Forum Discussion

Pipeline Trigger : Incoming JSON ,how to extract from body_json

5 Replies

Related Content

Processing incoming XML in webhook pipeline

Incoming JSON or Incoming Request JWT Token

Duration Fields with Pipelines

advanced query in a pipeline

Quickbase api in pipeline

Recent Discussions

Updating predecessors in a pipeline

Create Child Record, Save and then Edit button

Date to show as MMM YY

Pipeline Make Request - Return Make Request JSON Output into fields

An API(?) button to copy fields from the form, to other fields