@Ogiki_Collins Check this Workflow :
Data Scraping.zip (3.9 KB)
I was able to retrieve the data and loop through each one of them and aslo able to add the Company Details to the datatable. I have not added the Safety Details and the Fleet details. You can follow the same methods that I have followed to extract that as well.
I have only checked the execution for about 10 records, it was able to extract those 10 records and it’s company details. Since the time taken for it to extract is too much I just stopped the Execution . But it should be able to extract all the 300 records in it.
You can just Execute the Workflow and Check the Output at the end of extraction. Also you can just specify the number of records needed in the Property MaxNumberOfResults of Extract Structured Data Activity to just retrieve those many records only. If you keep it empty it will extract all data.
For Testing Purpose, I suggest you to keep only 10 or 5 records.