topic Re: How to publish a Microsoft Excel to hosted Table using ArcGIS API for Python? in ArcGIS API for Python Questions

How to publish a Microsoft Excel to hosted Table using ArcGIS API for Python?

Chai-YuanLiu — Tue, 24 Jul 2018 00:52:49 GMT

Ihave upload into a Microsoft Excel on portal,I want to publish it to a hosted Table.
If I use Item.publish() it will be ValueError,what should I do?

csv_file = 'D:/Test.csv'
csv_properties={'type':'Microsoft Excel','title':'Test','tags':['Test','Excel']}

csv_item = gis.content.add(csv_properties, None, None, None, None,'Test_Folder')

Re: How to publish a Microsoft Excel to hosted Table using ArcGIS API for Python?

MunachisoOgbuchiekwe — Sun, 12 Dec 2021 08:35:33 GMT

Hello Chai-Yuan Liu,

If you want to publish a csv to portal you can do the following....

import arcgis
import json
from arcgis.gis import GIS


gis = GIS(None,'username', 'password', verify_cert=False)


try:
    # Path to the CSV file
    pathToFile = r'path to file'
    # Add the CSV file to portal.
    item = gis.content.add({'title': 'testcsv'}, pathToFile)
    # If you want the table as a hosted feature layer then publish the item
    item.publish()
except Exception as e:
    print(e)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to publish a Microsoft Excel to hosted Table using ArcGIS API for Python?

GonzalezMorales — Thu, 03 Feb 2022 06:42:03 GMT

How could I publish the table as a hosted table instead of a hosted feature layer?