Extract specific JSON Values

Help Studio
, ,
1

Hi All,

This is my JSon output and I want to extract these values :from the below response

CPQ_Subscription_TCV__c
Signed_Stage_Date_Stamp__c

I used jsonQuoteResponseData.SelectToken(“dataArea.deal.quotes[0].CPQ_Subscription_TCV__c”).ToString() but getting object reference error

The image shows a sequence of actions in an automation workflow, including reading a JSON file, sending an HTTP request, deserializing JSON to fetch quote details, and displaying a specific value in a message box. (Captioned by AI)
The image shows a sequence of actions in an automation workflow, including reading a JSON file, sending an HTTP request, deserializing JSON to fetch quote details, and displaying a specific value in a message box. (Captioned by AI)1159×572 22.8 KB

2

Hi @dutta.marina

If json that you have pasted above is the final JSON then you can try below since json seems to me a direct json , no arrays or subtags

jsonQuoteResponseData.SelectToken(“CPQ_Subscription_TCV__c”).ToString

4

I removed the sample json snippet, because it looked “production-like”.

As to the question how to parse it, the latest WebAPI package has a new Sample JSON property that can be used to create an object from an input sample json. It works like this:

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.