1 Reply Latest reply on Apr 28, 2015 9:54 AM by philmodjunk

    Importing CSV Data from an API Call

    TerMight62

      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