overwrite response from API integration

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

Parents Reply Children
No Data