topic Re: Field Mapping parameter in geoanalytics append_data in ArcGIS API for Python Questions

Field Mapping parameter in geoanalytics append_data

AriMatiur — Sat, 06 Feb 2021 07:06:46 GMT

I try to append two feature layers in my ArcGIS portal. I'm using arcgis.geoanalytics module to do this. I manage to append these layers without using field mapping, I only pass the input layer and append layer parameter. However, I can't append these layers if I'm using field_mapping parameter. I have read this documentation but there is no example of field_mapping script. https://developers.arcgis.com/python/api-reference/arcgis.geoanalytics.manage_data.html#append-data

Maybe some example of field_mapping parameter would help me. Thank you!

Re: Field Mapping parameter in geoanalytics append_data

DavidPike — Sat, 06 Feb 2021 19:16:50 GMT

I think it may be a list of lists rather than KVPs:

field_mapping = [['kelurahan', 'kelurahan'], ['kecamatan','kecamatan']]

Re: Field Mapping parameter in geoanalytics append_data

AriMatiur — Sun, 07 Feb 2021 04:39:02 GMT

Hello David

It still not working

Re: Field Mapping parameter in geoanalytics append_data

DavidPike — Sun, 07 Feb 2021 14:07:51 GMT

Yeh I only came across that type of field mapping in another Python API tool, was worth a go I guess.

This tool's documentation for the field_mapping parameter is awful.

Re: Field Mapping parameter in geoanalytics append_data

AriMatiur — Mon, 08 Feb 2021 05:52:14 GMT

Yeah, other Python API tool field_mapping use list or KVPs. I don't know why this one is different.
Anyway, thank you very much.

Re: Field Mapping parameter in geoanalytics append_data

SarahAmbrose — Mon, 08 Feb 2021 14:19:17 GMT

Hi @AriMatiur,

The REST API documentation for the tool outlines the field mapping parameters here. Here is an example:

[
{ "inputLayerField": "Mean_Scales", "mappingType": "AppendField", "mappingValue": "Average_Scales" },
{ "inputLayerField": "Bonus", "mappingType": "Expression", "mappingValue": "$feature['WeeklyRate'] * 1.5" },
{ "inputLayerField": "Errors", "mappingType": "Expression", "mappingValue": "null" }
]

I agree that it's confusing that it's different than expected and then not clearly documented in the ArcGIS API for Python. I've put in a request to have the ArcGIS API for Python documentation include an example.

Please let me know if you have any follow up questions,

Sarah Ambrose
GeoAnalytics Team

Re: Field Mapping parameter in geoanalytics append_data

AriMatiur — Mon, 08 Feb 2021 14:49:30 GMT

It's working, thank you Sarah 😁