Forum Discussion

ThomasBoswick's avatar
ThomasBoswick
Qrew Trainee
6 years ago

API Import CSV Only Working When Table is Empty

I am utilizing the Quickbase API Import CSV function to import data into several tables. Everything was working fine until today, one of the tables was not updating. I did some troubleshooting and realized that the table is only updating when it is empty. If there are records in the table already, it will not throw an error (getting a response 200) but the data will not import either. Has anyone else experienced this issue? 
Data import and export
  • ChayceDuncan2's avatar
    ChayceDuncan2
    Qrew Cadet
    6 years ago
    What and how in particular are you trying to update? Quick Base will respond with a 200 code - even if no data in imported - but if you look at the actual XML response it might give you a clue. It sounds like you might have a uniqueness error in either the existing data or your import. 


    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
  • ThomasBoswick's avatar
    ThomasBoswick
    Qrew Trainee
    6 years ago
    Hello Chayce, thank you for your response. You were absolutely correct, when I looked at the XML response I noticed I was getting a Error: 51. It turns out two of the fields in the table were marked as 'Must Be Unique', when we removed this requirement, the import worked. Thank you for your help.

    Tom