{ "source": { "type": "dataLayer", "dataSource": { "type": "table", "workspaceId": "MyDatabaseWorkspaceIDSSR2", "dataSourceName": "egdb.DBADMIN.USLakes" } } }
Hi Tanu,
I have a table with a few columns as below:
It will return proper response when I use the following syntax:
{"source": { "type": "dataLayer", "dataSource": { "oidFields": "ObjectID", "query": "SELECT * FROM dbo.test2_datetime2", "type": "queryTable", "geometryType": "esriGeometryPoint", "workspaceId": "can_2023" } }}
However, if do not use SELECT *, instead, if I include spatial column name in my select statement, it will return an error:
Do you have any idea what is going on?
Thank you!
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.