How do I access JSON values from an http request field?

I want to use an http request field and then fill in other fields with values from the response.   The API sends the response as a JSON object.

  • You should be able to create a text field with a dynamic link to the API field.  As noted the API field will return a TEXT response, so if there is specific data you need you will need to parse the field.

    1 person likes this
  • You can add a text field that references the API field, just be aware it returns a PLAIN TEXT response, so you may need to parse it to have useable data.

    1 person likes this
  • Thank you, this lets me see the response.
    Do you know how I would parse this?  I want to fill a field with just one of the values from the json

  • Yep... you can use the JSONVAL command

    JSONVAL({{fieldwithJSONresponse}}, 'JSONfieldyouwant')

    ie... if you response is


    and you want the access token

    JSONVAL({{JSONRESPONSE}}, 'access_token')

    Hope this helps

    1 person likes this
  • Hi Sonny,

    Jamie is spot on. Take a look at our Knowledge Base article covering the REST Field Type.


Login or Signup to post a comment