Error when querying REST API

476
9
Jump to solution
02-05-2021 08:08 AM
MollyMoore
New Contributor III

I am pretty new to working with the REST API and I'm trying to query a feature service on our organization's server using arcpy. Here is my code:

 

fs_url = r"https://maps.waterlandlife.org/arcgis/rest/services/PNHP/NHAEdit/FeatureServer/1/query?where=STATUS='C'&outFields=*&returnGeometry=true&f=JSON" 
fs = arcpy.FeatureSet()
fs.load(fs_url)

 

 

I have tried to change the options for nearly all of the parameters here and tried including other parameters or excluding some of these. I keep getting the following error:

 

 

RuntimeError: RecordSetObject: Cannot open table for Load

 

 

I'm able to load the feature set fine without the query and have looked at a ton of resources online and can't find any solutions that have worked. Can anyone help me out with what I'm doing wrong? Thanks!

0 Kudos
3 Solutions

Accepted Solutions
JoshuaBixby
MVP Esteemed Contributor

In this case, the FeatureSet - ArcGIS Pro | Documentation gives an example, FeatureSet example 2.  The query needs to be passed as a separate argument and not part of the URL.

View solution in original post

JeffK
by
Occasional Contributor III

I think the list items need to be in quotes.

 

nha_expression = "NHA_JOIN_ID IN ('{}')".format("','".join(f for f in nha_ids))

 

to make it

 

"NHA_JOIN_ID IN ('xxx42966','xxx42967','xxx43009')"

 

View solution in original post

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

Swap the double and single quotes:   SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation

Strings must always be enclosed in single quotation marks in queries, for example: STATE_NAME = 'California'

View solution in original post

9 Replies
DavidPike
MVP Frequent Contributor

have you supplied a token with the url? &token=

0 Kudos
MollyMoore
New Contributor III

I have not. I figured since it was letting me use the feature service layer without the query that this wasn't the issue. But, I'll try this now.

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

Are you using Pro or ArcGIS Desktop/ArcMap?  If you are using ArcMap, what you are trying won't work.  If you are using Pro, you need to break your query out separate from the URL to the hosted feature layer.

0 Kudos
MollyMoore
New Contributor III

Yes, this is being used in a toolbox that I'm running through Pro. Do you mean that I need to bring in the data and then query it in another step? Or is there a way to separate the query from the URL in the feature service request? If the latter, is there an example of this somewhere? I couldn't find anything like this.

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

In this case, the FeatureSet - ArcGIS Pro | Documentation gives an example, FeatureSet example 2.  The query needs to be passed as a separate argument and not part of the URL.

View solution in original post

MollyMoore
New Contributor III

Thank you! This works for the given example. However, I'm unable to pass a list query. I can pass the list query without error, but it ignores it and loads all features into the feature set. This is what I'm passing:

nha_expression = "NHA_JOIN_ID IN ({0})".format(','.join(nha_ids))
nha_core_fs = arcpy.FeatureSet()
nha_core_fs.load(nha_core_url,nha_expression)

The nha_expression looks like this:

'NHA_JOIN_ID IN (xxx42966,xxx42967,xxx43009)'

 

I am able to drop the necessary records after I load in the features with an update cursor, but I figured it would be a lot more elegant and faster to just not load them in the first place through the where clause, so if anyone has ideas about why it's not honoring the query, I'd appreciate it!

0 Kudos
JeffK
by
Occasional Contributor III

I think the list items need to be in quotes.

 

nha_expression = "NHA_JOIN_ID IN ('{}')".format("','".join(f for f in nha_ids))

 

to make it

 

"NHA_JOIN_ID IN ('xxx42966','xxx42967','xxx43009')"

 

View solution in original post

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

Swap the double and single quotes:   SQL reference for query expressions used in ArcGIS—ArcGIS Pro | Documentation

Strings must always be enclosed in single quotation marks in queries, for example: STATE_NAME = 'California'

View solution in original post

MollyMoore
New Contributor III

This did the trick (with the single quotes). Thank you all!

0 Kudos