Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
fdev2020
Contributor
Contributor

Can not parse my json using TextractJSON

Hi,

I got data from web service from salesforce throught a webhook but i got this error when i try to extract the json using tExtractJSON:

tExtractJSONFields_2 - net.minidev.json.parser.ParseException: Unexpected token r at position 13.

Here is the data i got throught the webhook when i just send this object

{"refDossier":"B4795609"}

:

[{"data":"{"refDossier":"B4795609"}","type":"application/json"}]

notified that i got the data in String

Thanks for you help.

KR.

Labels (6)
1 Reply
Anonymous
Not applicable

Hi

Make sure it is a valid json string, if not, need to remove extra characters such as double quote " before tExtractJSON

 

Regards

Shong