<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: d</title>
    <description>The latest articles on DEV Community by d (@devbohan).</description>
    <link>https://dev.to/devbohan</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1028415%2Ff5b0b93f-e46e-47f3-bd77-8f15ef09ca7e.png</url>
      <title>DEV Community: d</title>
      <link>https://dev.to/devbohan</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/devbohan"/>
    <language>en</language>
    <item>
      <title>react wrapper for autodesk forge viewer</title>
      <dc:creator>d</dc:creator>
      <pubDate>Fri, 17 Feb 2023 07:04:23 +0000</pubDate>
      <link>https://dev.to/devbohan/react-wrapper-for-autodesk-forge-viewer-17i2</link>
      <guid>https://dev.to/devbohan/react-wrapper-for-autodesk-forge-viewer-17i2</guid>
      <description>&lt;h2&gt;
  
  
  0. if you have following requirments, you might need to know &lt;a href="https://github.com/autodesk-platform-services/viewer-react-sample" rel="noopener noreferrer"&gt;this sample&lt;/a&gt;
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;familiar with react but not very much for autodesk products or forge-viewer&lt;/li&gt;
&lt;li&gt;hush to get contents on a forge viewer viewable model&lt;/li&gt;
&lt;li&gt;working on a react project and embedded with some forge viewer contents from scratch&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  1. get &lt;a href="https://nodejs.org/en/" rel="noopener noreferrer"&gt;nodejs&lt;/a&gt;
&lt;/h2&gt;



&lt;h2&gt;
  
  
  2. read some autodesk documents for minimum
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://aps.autodesk.com/en/docs/oauth/v1/reference/http/authenticate-POST/" rel="noopener noreferrer"&gt;token&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://aps.autodesk.com/en/docs/data/v2/reference/http/projects-project_id-items-item_id-GET/" rel="noopener noreferrer"&gt;urn&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;



&lt;h2&gt;
  
  
  3. &lt;a href="https://aps.autodesk.com/blog/building-simple-react-wrapper-viewer" rel="noopener noreferrer"&gt;find this article&lt;/a&gt;
&lt;/h2&gt;



&lt;h2&gt;
  
  
  4. &lt;a href="https://github.com/autodesk-platform-services/viewer-react-sample" rel="noopener noreferrer"&gt;find this code-sample&lt;/a&gt;
&lt;/h2&gt;



&lt;h2&gt;
  
  
  5. clone 4. and run locally with
&lt;/h2&gt;

&lt;p&gt;&lt;br&gt;
 &lt;code&gt;npm start&lt;/code&gt;&lt;br&gt;
&lt;/p&gt;



&lt;h2&gt;
  
  
  6. check parts locally, you might find the mistery number in red box in &lt;a href="https://dev.to/devbohan/fetch-database-data-from-model-derivative-api-and-check-the-detail-in-it-with-sqliteweb-package-1f32"&gt;my last post&lt;/a&gt;: response of [step 3: peek data with query]
&lt;/h2&gt;



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fhuubma2traowynpb3gy7.jpg" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fhuubma2traowynpb3gy7.jpg" width="671" height="517"&gt;&lt;/a&gt;&lt;/p&gt;

</description>
      <category>seo</category>
      <category>marketing</category>
      <category>contentwriting</category>
    </item>
    <item>
      <title>fetch database data from `model derivative api` and check the detail in it with `sqlite_web` package</title>
      <dc:creator>d</dc:creator>
      <pubDate>Fri, 17 Feb 2023 03:32:14 +0000</pubDate>
      <link>https://dev.to/devbohan/fetch-database-data-from-model-derivative-api-and-check-the-detail-in-it-with-sqliteweb-package-1f32</link>
      <guid>https://dev.to/devbohan/fetch-database-data-from-model-derivative-api-and-check-the-detail-in-it-with-sqliteweb-package-1f32</guid>
      <description>&lt;h2&gt;
  
  
  step 1: fetch download url
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;a autodesk account, a relevant bim360 project and forge application are necessary. &lt;/li&gt;
&lt;li&gt;retrive forge token, 2 legged or 3 legged is okay, in this sample using 2 legged&lt;/li&gt;
&lt;li&gt;retrive the file item&lt;a href="https://aps.autodesk.com/en/docs/data/v2/tutorials/download-file/" rel="noopener noreferrer"&gt;check the tutorial and following step 1 to step 4&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;&lt;a href="https://aps.autodesk.com/en/docs/data/v2/reference/http/projects-project_id-items-item_id-GET/" rel="noopener noreferrer"&gt;retrive the urn and derivative urn&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://aps.autodesk.com/en/docs/model-derivative/v2/tutorials/translate-to-obj/task4-download-obj-file/#step-2-obtain-signed-cookie" rel="noopener noreferrer"&gt;pre-download&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://aps.autodesk.com/en/docs/model-derivative/v2/tutorials/translate-to-obj/task4-download-obj-file/#step-3-download-obj-file" rel="noopener noreferrer"&gt;download&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;update extension of download file to db(in my case, it was *.bin)&lt;/li&gt;
&lt;/ol&gt;



&lt;h2&gt;
  
  
  fyi:
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://learning.postman.com/docs/sending-requests/responses/#saving-responses" rel="noopener noreferrer"&gt;how to download file from postman&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://learning.postman.com/docs/sending-requests/cookies/#using-the-cookie-manager" rel="noopener noreferrer"&gt;how to set cookies on postman if necessary&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;



&lt;h2&gt;
  
  
  step 2: set up &lt;a href="https://pypi.org/project/sqlite-web/" rel="noopener noreferrer"&gt;sqlite_web&lt;/a&gt; and run it
&lt;/h2&gt;



&lt;h2&gt;
  
  
  step 3: peek data with query
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://aps.autodesk.com/blog/accessing-design-metadata-without-viewer" rel="noopener noreferrer"&gt;...we can start slicing &amp;amp; dicing the sqlite database in any way we need... &lt;/a&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="n"&gt;_objects_id&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="n"&gt;dbId&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;_objects_id&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;external_id&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="n"&gt;externalId&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;_objects_attr&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;name&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="n"&gt;propName&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;_objects_val&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;value&lt;/span&gt; &lt;span class="k"&gt;AS&lt;/span&gt; &lt;span class="n"&gt;propValue&lt;/span&gt;
&lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;_objects_eav&lt;/span&gt;
    &lt;span class="k"&gt;INNER&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;_objects_id&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;_objects_eav&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;entity_id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;_objects_id&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt;
    &lt;span class="k"&gt;INNER&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;_objects_attr&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;_objects_eav&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;attribute_id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;_objects_attr&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt;
    &lt;span class="k"&gt;INNER&lt;/span&gt; &lt;span class="k"&gt;JOIN&lt;/span&gt; &lt;span class="n"&gt;_objects_val&lt;/span&gt; &lt;span class="k"&gt;ON&lt;/span&gt; &lt;span class="n"&gt;_objects_eav&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;value_id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;_objects_val&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="n"&gt;id&lt;/span&gt;
&lt;span class="k"&gt;WHERE&lt;/span&gt; &lt;span class="n"&gt;propName&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nv"&gt;"{your-propName}"&lt;/span&gt; &lt;span class="k"&gt;AND&lt;/span&gt; &lt;span class="n"&gt;propValue&lt;/span&gt; &lt;span class="k"&gt;LIKE&lt;/span&gt; &lt;span class="nv"&gt;"%{your-propValue}%"&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;





&lt;p&gt;and finally check you sqlite_web browser.&lt;/p&gt;

</description>
      <category>python</category>
      <category>csharp</category>
      <category>javascript</category>
      <category>career</category>
    </item>
  </channel>
</rss>
