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
  • Hi

    Could you please explain what you mean by this statement? 

    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.

Reply
  • Hi

    Could you please explain what you mean by this statement? 

    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.

Children
No Data