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 sreedevi0001
Could you please explain what you mean by this statement?
sreedevi0001 said:that Appian complains due to special characters
As far as I know, Appian accepts special characters in the dictionary, but it will not accept them for the data type field labels. So, if you're using these inside records, you can simply ignore the fields from the integration & focus on the required fields. If you need them inside the record, then you can create the dataype fields without special characters and map the values inside the expression rule used as record source.
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.