topic Re: Parse JSON response to get one field value in APIs & Integrations

Parse JSON response to get one field value

KKulkarni4 — Fri, 20 Sep 2024 10:43:40 GMT

The steps to achieve this, a basic sketch, goes like this:

Send Data to the Webhook: When creating the company in HubSpot, make sure to send all necessary data to the webhook endpoint.
Receive JSON Response: Capture the JSON response returned by the webhook endpoint.
Extract Customer ID: Parse the JSON response to extract the Customer ID.
Update HubSpot Property: Use the HubSpot API to update the custom contact property with the extracted Customer ID.

Re: Parse JSON response to get one field value

kennedyp — Fri, 20 Sep 2024 17:17:24 GMT

Hi @KKulkarni4! Welcome to the Community-- happy to have you here 😊

Thanks for sharing this process. Are you utilizing this in your own HubSpot instance or have you implemented this for anyone else?

Be sure to also ask any relevant questions you have so our Community members can contribute!

Best,
Kennedy

Re: Parse JSON response to get one field value

KKulkarni4 — Tue, 24 Sep 2024 11:35:54 GMT

I am planning to use this for own instance, basically I want to know How to parse the JSON response from Webhook in workflow and pass the parsed value to Set property event.

Re: Parse JSON response to get one field value

kennedyp — Thu, 26 Sep 2024 16:19:28 GMT

I'd like to invite some of our developer experts to this thread!

Hey @skimura, @noahmckeon, @alyssamwilie, @miljkovicmisa do y'all have any tips for @KKulkarni4?

Thanks!

Re: Parse JSON response to get one field value

skimura — Fri, 27 Sep 2024 00:33:54 GMT

@KKulkarni4

Hi.

How about trying the following?

I hope this helps.

1. add [Send a webhook]

set [webhook URL].

[Test action] > [Test]

2. get API [response parameter].

after [Test] click, If API call succeeded, [response] appears.

3. choose response parameter.

this case, I selected [userId].

*don't forget save.

4. Edit [Set Property value].

choose [Action outputs].

5. Set property value to [userId].

this case, [userId] is selectable.

*If necessary, consider API response error cases.
example, set property value when API succeeded only.

Thanks.

@kennedyp

Thanks for mention.