Forum Discussion

RussellBeaubien's avatar
RussellBeaubien
Qrew Cadet
5 years ago

API Call add and update records in one function

Currently I am importing a file into an existing table matching to records based on the KEY field I made ("customerID-Invoice#"). There are hundreds of records in this file, some do not match the Qui...
APIs and custom code
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
If you're using the standard API, you'll receive an error stating that the record doesn't exist. If you want to pull records in using the API and want to effectively do an Upsert, you'll have to do one of two things. 1) Import your data via CSV using API_ImportFromCSV  call OR 2) Use the new JSON API for Records which supports Upserts.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
  • RussellBeaubien's avatar
    RussellBeaubien
    Qrew Cadet
    5 years ago
    So If I use API-ImportFromCSV when I import it will update existing and create new if it doesn't match then?

    ------------------------------
    Russell Beaubien
    ------------------------------
    • BlakeHarrison's avatar
      BlakeHarrison
      Qrew Captain
      5 years ago
      Yes.

      ------------------------------
      Blake Harrison
      bharrison@datablender.io
      DataBlender - Quick Base Solution Provider
      Atlanta GA
      404.800.1702 / http://datablender.io/
      ------------------------------
      • RussellBeaubien's avatar
        RussellBeaubien
        Qrew Cadet
        5 years ago
        Awesome!!
        thank you for the Help

        ------------------------------
        Russell Beaubien
        ------------------------------