Search code examples
autodesk-forgeautodesk-model-derivative

SQLite property DB and GET {urn}/metadata/{guid}/properties seem to return some mismatching dbIds (objectIDs)

I try to get the dbIds of Navisworks items which have a specific property.

The NWDs get translated to SVF2, using the default settings.

When I query the property DB, I get different dbIds than the dbIds that are returned from the {urn}/metadata/{guid}/properties endpoint.

Query with results:query with results

Snippet of the corresponding json data:

[{
    "objectid": 11,
    "name": "3D Solid",
    "externalId": "0/1/0",
    "properties": {
        "Neanex Connector": {
            "ibcNAME": "Cone-1",
            "ibcGUID": "6453c4c067d1476db9c68c4066e291c4"
        }
    }
},
{
    "objectid": 2,
    "name": "SomeSolids-1.nwd",
    "externalId": "0",
    "properties": {
        "Neanex Connector": {
            "ibcNAME": "SomeSolids-1",
            "ibcGUID": "2613704afaeb4e68bcb1600a737df0b7"
        }
    }
},
{
    "objectid": 27,
    "name": "3D Solid",
    "externalId": "1/5/0",
    "properties": {
        "Neanex Connector": {
            "ibcNAME": "Wedge-2",
            "ibcGUID": "25d5fb2daebe4a3fb3eb1c671012d5f3"
        }
    }
},
{
    "objectid": 3,
    "name": "SomeSolids-2.nwd",
    "externalId": "1",
    "properties": {
        "Neanex Connector": {
            "ibcNAME": "SomeSolids-2",
            "ibcGUID": "425212b48a45457f9f9d5192e84bb0a4"
        }
    }
}]

Summary:

SQLite dbId External ID json dbId GUID
2 0 2 2613704afaeb4e68bcb1600a737df0b7
6 0/1/0 11 6453c4c067d1476db9c68c4066e291c4
15 1 3 425212b48a45457f9f9d5192e84bb0a4
27 1/5/0 27 25d5fb2daebe4a3fb3eb1c671012d5f3

Which dbIds are the correct ones?

Why the differences?

Regards

Wolfgang

Solution

  • As I know, the dbIds in SQLite DB will be svf dbIds. If you want to get svf dbIds after translating to svf2, you will need to call the below APIs with an extra header x-ads-derivative-format: fallback. Otherwise, the objectIds you got from the properties API will be svf2 dbIds.