I have an API response that has special characters in the attribute keys. Due to which, the sync fails when I integrated the API response to site records.
Here is the API - https://data.cityofnewyork.us/resource/5kqf-fg3n.json?
Response has the following attributes in the body that Appian complains due to special characters
":@computed_region_efsh_h5xi":"24670",":@computed_region_f5dn_yrer":"41",":@computed_region_yeji_bk3q":"3",":@computed_region_92fq_4b7q":"24",":@computed_region_sbqj_enih":"61"
How do I remove those attributes as those are anyway insignificant for the application. Please suggest all the possible ways
a) Can we do that in API integration call itself, by handing the API response and removing unwanted JSON attributes.
b) In the Records and data source sync, ignore certain fields
Here are the screenshots of the API response
Discussion posts and replies are publicly visible
Hi there,
I'm not sure if this will help you, but perhaps you could try the code below:
a!localVariables( local!a: tostring(rule!YOUR_API().result.body), local!b: substitute(local!a,"\""","" ), a!fromJson(local!b)[1] )
This is only vanilla scenario and will not work in exception but you can adjust from there, it is just an idea.
Hope that helps.
Acacio B.