Support Article
JSON Response error due to @ character
SA-32308
Summary
Connect-REST method is connecting to a REST service that returns a element named @total_records in Json response.
Error Messages
The reference @total_records is not valid. Reason: invalid property name: '@total_records'
Steps to Reproduce
- Creat rest service.
- Note that response should be Json which is having "@" symbol before every property.
- Consume the rest URL through integration wizard.
- After created the rules, go to Connect rest rule, and modify the response map to key as JSON & page property.
- Create the activity and call the above connect rest method.
Root Cause
While parsing the Json response, referring "total_records" property instead of "@total_records" property.
Resolution
Local-change is to add pzExternalName qualifier to the property.
Go to Property> Advanced tab >property qualifiers, and add below entry:
Qualifier: pzExternalName
Value: @total_records
Published January 20, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.