I have an API that returns the HTML of a page from another site, which is a profile page for a company that contains its name, address, phone number etc. The data elements I want are in the body of the HTML response.
I can pull the text of the body and put that into a data thing just now, but what i want to to is set up a backend workflow that calls the API, takes the body of the HTML as text and then run the toolbox plug into get data by element ID., extract the data set i want, add it to the database then throw away what I don’t want.
Using the Toolbox plugin i could do this by putting the API result into an HTML element on a page then extract the data i want through the element ID’s using a workflow, but I just want this to run in the background to automatically add to the database each time the API is run on a schedule.
Any tips would be greatly appreciated.