AnsweredAssumed Answered

Append data from csv to hosted table using Python API

Question asked by jslauzon on Mar 30, 2020
Latest reply on Sep 10, 2020 by bck2_cdcarcgis

I would like to append data to a hosted Table from a csv file using the Python API.

 

This can be done in AGOL, by choosing Update Data -> Append data to layer, how would that be done in Python.

I've tried to follow this: Append Features | ArcGIS for Developers 

 

When I try to append the table using:

dataset_tbl.append(item_id=new_csv_item_id, upload_format='csv')

I get an error message "Unable to append data. Missing appendSourceInfo parameters.

 

I see that I should enter something here, but I'm not sure what.

source_info

optional dictionary. This is only needed when appending data from excel or csv. The appendSourceInfo can be the publishing parameter returned from analyze the csv or excel file.


Note that this table has no geometry, it is a data table only. Also this table is joined, so it cannot be overwritten.  

Outcomes