How to work with USPTO website and create table based on JSON file

Question

We have a database in Quickbase that stores records relating to patents..&nbsp; We want to know if the following is feasible to do in Quickbase:

.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Create a temp table based on Json returned form peds (patents REST API)
sort table
&nbsp;run query for docs that Match doc codes you want to download and download them.

We would like to know if this is possible.&nbsp; Thank you in advance.

------------------------------John Hajian------------------------------

gregorygebhardt · Accepted Answer

I believe this is possible although I dont think I haven't done this exactly, I have done all the pieces of this as some point.&nbsp; Pipelines will be what you need to use.&nbsp;
1.The general methodology in pipelines would be to: fetch a JSON &gt;iterate over Json Records&gt; add Records to your Table.
The rest&nbsp; is done with reporting in Native Quickbase (sort &amp; filter).&nbsp; Your hardest part in my opinion will be fetching json IMO.
Here are some other paths and thoughts but without building and testing I wouldn't know for sure the exact way.&nbsp; Sometimes there are limitations in Pipelines sometimes limitations in your API call to get the json response.
2. Fetch a JSON &gt;define a table&gt;iterate over Json Records&gt;add rows to that table&gt;download CSV&gt;Fetch CSV&gt;Iterate over CSV records&gt; add Records to your Table
or
3. Webhook Make Request&gt;iterate over records with Jinja code&gt; ??------------------------------Greg------------------------------

Forum Discussion

How to work with USPTO website and create table based on JSON file