Quickbase Discussions

 View Only
  • 1.  Pipeline Trigger : Incoming JSON ,how to extract from body_json

    Posted 8 days ago
    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:Array[1]
    0:"Prashant Maheshwari"


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


  • 2.  RE: Pipeline Trigger : Incoming JSON ,how to extract from body_json

    Posted 8 days 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
    ------------------------------



  • 3.  RE: Pipeline Trigger : Incoming JSON ,how to extract from body_json

    Posted 7 days 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.
    ----








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



  • 4.  RE: Pipeline Trigger : Incoming JSON ,how to extract from body_json

    Posted 7 days ago

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

    Mine looks like this:



    ------------------------------
    Jeff Peterson
    ------------------------------



  • 5.  RE: Pipeline Trigger : Incoming JSON ,how to extract from body_json

    Posted 7 days ago
    Thanks Jeff,

    This will help me talk to developer

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



  • 6.  RE: Pipeline Trigger : Incoming JSON ,how to extract from body_json

    Posted 3 days 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
    ------------------------------