I need someone who can improve a script for us which is used to extract search results from a 3rd party API.
Quick info about the API:
REST Post API
Gives access to product database
We are currently using 2 features of the API.
(upload url > get key)
(search using the “Key” received from (1) and get results.
We already have these 2 scripts created:
I have a fully working python script for the the 2 api method request above along with another feature which creates a CSV file products details along with .txt files with the data found which was used to create the product details csv. The Python script was setup for MAC.
Google sheet script:
Also, I started building a script into google sheet, but only the [login to view URL] url >get key feature of the API is fully working in that script.
Project information and requirements:
I am running into some problems running the python script on my Mac which are related to the Mac memory and http requests and not able to get the data fast enough.
I would like to use google sheets to get the data. So, I need some help to add the second API method request mentioned above ( 2.(search using the “Key” received from (1) and get results).