AnsweredAssumed Answered

Importing CSV Data from an API Call

Question asked by TerMight62 on Apr 27, 2015
Latest reply on Apr 28, 2015 by philmodjunk

Title

Importing CSV Data from an API Call

Post

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.

https://www.dropbox.com/s/x8557zwspx792me/historicdata%20%286%29.csv?dl=0

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

Outcomes