Skip to main content
Question

API Import CSV Only Working When Table is Empty

  • April 3, 2019
  • 0 replies
  • 65 views
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? 
    This topic has been closed for replies.

    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
    • Author
    • Registered
    • April 3, 2019
    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 
    Terms & ConditionsAccessibility statement