step 1: fetch download url
- a autodesk account, a relevant bim360 project and forge application are necessary.
- retrive forge token, 2 legged or 3 legged is okay, in this sample using 2 legged
- retrive the file itemcheck the tutorial and following step 1 to step 4
- retrive the urn and derivative urn
- pre-download
- download
- update extension of download file to db(in my case, it was *.bin)
fyi:
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.
Top comments (0)