@Anonymous User- Ok so this is working off the solution you helped me with last week. now just trying to tweak to write to a Enterprise SDE Database.
1. read from URL
2. write to local JSON file
3. JSONtoFeatures (Local JSON file , New Output Feature Class)
I am not doing anything crazy with the File name.
Is there a character limit in the Connection File String?
THIS WORKS if I write to a local File Geodatabase.
import arcpy
import json
import uuid
import os
import re
import requests
# SCRIPT GLOBAL VARIABLES
arcpy.env.workspace = 'E:/ArcGIS_Server/ArcGIS/Trail/'
fsURL = "https://dwr.virginia.gov/-/api/v1/vbwt-sites"
dataInput = "E:/ArcGIS_Server/ArcGIS/Trail/JSON_New4.json"
output_fc = "E:/ArcGIS_Server/AdminConnectionFile.sde/Trail.DBO.VABWTS"
inFeatures = "VABWTS"
tempLayer = "testLayer"
fld_dict = {}
new_dict = {}
converted_list = []
def main():
# Read URL and truncate long fields
readURL()
# Add New Feature Class
addNewFC()
def readURL():
r3 = requests.get(fsURL)
data = json.loads(r3.text)
# Added this So I could use it in the For loop
data1 = {"BirdTrailLocations": data }
for i in data1['BirdTrailLocations']:
feat_dict = {}
feat_dict["geometry"] = {"x": i["site_longitude"], "y": i["site_latitude"]}
feat_dict["attributes"] = i
converted_list.append(feat_dict)
new_dict = {"geometryType" : "esriGeometryPoint",
"spatialReference" : {"wkid" : 4326},
'fields': [{"name": str(k), "type": "esriFieldTypeString", "alias": str(k), "length": 255} for k, v in data[0].items()],
'features': converted_list}
# write this truncated capture to a local file for further processing this is a requirement for this to work per ESRI
writeLocalFileURLText(new_dict)
def writeLocalFileURLText(urlResults):
new_dict = urlResults
print (new_dict)
with open(dataInput, 'w') as f:
json.dump(new_dict, f)
def addNewFC():
arcpy.env.overwriteOutput = True
arcpy.JSONToFeatures_conversion(dataInput, output_fc)
arcpy.env.overwriteOutput = False
ERROR:
Traceback (most recent call last):
File "E:\ArcGIS_Server\ArcGIS\Trail\AddPoints_w_changeFieldTypes3.py", line 403, in <module>
main()
File "E:\ArcGIS_Server\ArcGIS\Trail\AddPoints_w_changeFieldTypes3.py", line 49, in main
deleteExistingFC()
File "E:\ArcGIS_Server\ArcGIS\Trail\AddPoints_w_changeFieldTypes3.py", line 144, in deleteExistingFC
arcpy.JSONToFeatures_conversion(dataInput, output_fc)
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\conversion.py", line 1171, in JSONToFeatures
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\conversion.py", line 1168, in JSONToFeatures
retval = convertArcObjectToPythonObject(gp.JSONToFeatures_conversion(*gp_fixargs((in_json_file, out_features, geometry_type), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000206: Cannot create FeatureClass 'E:\ArcGIS_Server\AdminConnectionFile.sde\Trail.DBO.VABWTS'. Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'R34_pk'. Cannot insert duplicate key in object 'dbo.VABWTS'. The duplicate key value is (0).] [BirdingTrail.DBO.VABWTS]
Failed to execute (JSONToFeatures).
