Importing CSV Data from an API Call
I have a DB for a small ISP. once a month we run a Bandwidth report. I can Request a CSV file showing the Customer Usage for the month, using Monitoring softwares' API. I would like to import only one Cell's data not all the data. Ive attached the .CSV file. The Data I need is in Cell C32.
If it is possible to Import only that Value. than I would like to have this all handled by a script to Create the API Call--> then save the file as a temporary file --> Extract the Data need---> then trash the Temp File.
Not sure if this is possible.
any help is appreciated
Not sure if this will work, but maybe you can use Insert from URL to download/insert the file into a container field. From there you can export field contents and use import records to pull the data from a csv file into FileMaker.