created web api with below code but getting below error
local!entities: a!queryEntity( entity: cons!TI_FINALEXCELTODATABASESTORE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: true ).data,
An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TIFinalExcelToDatabaseDT7969], query: [queryentity expression], order by: [[Sort[null asc]]], filters:[null])
Discussion posts and replies are publicly visible
From the error it looks like it is expecting values for sort and filter parameters. Although the sort and filter parameter are optional in a!pagingInfo(), the a!query() should work without these parameters. Make sure the constant "cons!TI_FINALEXCELTODATABASESTORE" points to correct entity and publish the Data Store.