Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Folks,
Because my server throws a weird error 8 out of 10 times I call "location.GetAppIdentifiers()", I'd like to switch to using the REST APIs since those have never failed me.
Does anyone know how to retrieve the sheet information given an appId using rest? I'm looking to retrieve the Title, the Sheet Path/Id. I assume this would be found using Engine and not Repository endpoints, but I'm having trouble find a service that returns this data.
My server is Nov 2019 Patch 3 if that makes a difference.
Any help is greatly appreciated.
My default would be to call GET /qrs/app/object/full?filter=(objectType = 'sheet') but I am receiving The comparison expression contains an unsupported operator: objectType = 'sheet' as a response. I'm pinging some folks about that response.
The following is working fine for me:
POST /qrs/App/Object/table?filter=((objectType eq 'sheet'))
Body:
{
"entity": "App.Object",
"columns": [
{
"name": "id",
"columnType": "Property",
"definition": "id"
},
{
"name": "description",
"columnType": "Property",
"definition": "description"
},
{
"name": "name",
"columnType": "Property",
"definition": "name"
},
{
"name": "objectType",
"columnType": "Property",
"definition": "objectType"
},
{
"name": "owner",
"columnType": "Property",
"definition": "owner"
},
{
"name": "approved",
"columnType": "Property",
"definition": "approved"
},
{
"name": "published",
"columnType": "Property",
"definition": "published"
},
{
"name": "modifiedDate",
"columnType": "Property",
"definition": "modifiedDate"
},
{
"name": "app.name",
"columnType": "Property",
"definition": "app.name"
},
{
"name": "app.stream.name",
"columnType": "Property",
"definition": "app.stream.name"
}
]
}
I think the problem in the first call is simply that you used '=' instead of 'eq' in the filter. This works for me:
GET /qrs/app/object/full?filter=(objectType eq 'sheet')
Yep, @Øystein_Kolsrud . That's what I get for working on Sunday!