DEV Community

d
d

Posted on

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:

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}%"
Enter fullscreen mode Exit fullscreen mode

and finally check you sqlite_web browser.

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs