API_ImportFromCSV help how to use in C# and .NET

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I am trying to update qbtable using CSV file using the API calls. Upon checking your API documentation all the examples are created just for XML usage only. It looks like the document drafter assumed the whole Quickbase users will be using XML to work with quick base.  Can anyone show me how to call API_ImportFromCSV in C#. I have been using the single record update so far which resulted in too much API call charges from QuickBase.

Any help is much appreciated.

Photo of Joseph Kurian

Joseph Kurian

  • 20 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
There is a C# SDK for QuickBase located on GitHub. Information about API_ImportFromCSV is located here:



https://github.com/QuickbaseAdmirer/QuickBase-C-Sharp-SDK/blob/master/Intuit.QuickBase.Core/ImportFr...
Photo of Joseph Kurian

Joseph Kurian

  • 20 Points
Blake thanks for the response.
I saw the sdk and cmpiled into a DLL and using it in my project. But I am not sure what the order I have call the functions in the class.  Below is how I coded it

ImportFromCSV.Builder cBuilder = new ImportFromCSV.Builder(gTicket, gToken, gMainurl, gQbTableid, gCSVRec);   // gCSVRec is the name of the CSV file

cBuilder.SetCList("8.7.12.9.11.6.13.10.14.15.16.17.24.19.18.20.23.21.22");  // list of fields
cBuilder.SetSkipFirst(true);  
cBuilder.Build();

Should I call any other function from the class or what I am doing wrong here?

Thank you very much for your help.