Solved! Go to Solution.
{ "source": { "type": "dataLayer", "dataSource": { "type": "table", "workspaceId": "MyDatabaseWorkspaceIDSSR2", "dataSourceName": "egdb.DBADMIN.USLakes" } } }
{ "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!