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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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