API_ImportFromCSV
Can we update and add record using single API_ImportFromCSV api call? My requirement is want move record data from table to table by homepage button click. If record is already exist in 2nd table ...
Forum Discussion
Hi Chethana,
It is possible when doing an ImportfromCSV for new records and existing records to be updated. The trick of that is the key between the two tables needs to be consistent , there needs to be a unique identifier that they share in order for the API to have the necessary logic to combine records or create a new record. In the ImportfromCSV call you would want to take advantage of the mergeFieldId parameter, you can find more in the help doc for API_ImportfromCSV in our API Guide
I hope this suggestion is helpful Chethana.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
It is possible when doing an ImportfromCSV for new records and existing records to be updated. The trick of that is the key between the two tables needs to be consistent , there needs to be a unique identifier that they share in order for the API to have the necessary logic to combine records or create a new record. In the ImportfromCSV call you would want to take advantage of the mergeFieldId parameter, you can find more in the help doc for API_ImportfromCSV in our API Guide
|
mergeFieldId |
With this parameter, the import uses the field specified as the key, instead of the key field for the table.
To specify the field, use the field ID, for example:
For more details, read an article about the parameter on the Quick Base Community site. |
I hope this suggestion is helpful Chethana.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Thank you Evan..It worked fine for me.
------------------------------
Chethana Shetty
------------------------------
------------------------------
Chethana Shetty
------------------------------