fetch database data from `model derivative api` and check the detail in it with `sqlite_web` package

step 1: fetch download url

1. a autodesk account, a relevant bim360 project and forge application are necessary.
2. retrive forge token, 2 legged or 3 legged is okay, in this sample using 2 legged
3. retrive the file itemcheck the tutorial and following step 1 to step 4
4. retrive the urn and derivative urn
5. pre-download
6. download
7. update extension of download file to db(in my case, it was *.bin)

fyi:

• how to download file from postman
• how to set cookies on postman if necessary

step 2: set up sqlite_web and run it

step 3: peek data with query

...we can start slicing & dicing the sqlite database in any way we need...

SELECT _objects_id.id AS dbId, _objects_id.external_id AS externalId, _objects_attr.name AS propName, _objects_val.value AS propValue
FROM _objects_eav
    INNER JOIN _objects_id ON _objects_eav.entity_id = _objects_id.id
    INNER JOIN _objects_attr ON _objects_eav.attribute_id = _objects_attr.id
    INNER JOIN _objects_val ON _objects_eav.value_id = _objects_val.id
WHERE propName = "{your-propName}" AND propValue LIKE "%{your-propValue}%"

and finally check you sqlite_web browser.