Forum Discussion

RyanStanford1's avatar
RyanStanford1
Qrew Captain
7 years ago

API_AddRecord from JavaScript Array creating duplicates

Hello, I am using Javascript to pull out a row from one table, remove duplicates, and then I want to upload those results into another table, one record for each value. Distinct is the array, an...
Quickbase Automations
Tips and tricks
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
7 years ago
Try this:

var dbid = "your application dbid";
var dbidTable = "your table dbid"
var apptoken = "your application token";
$.ajaxSetup({data: {apptoken: apptoken}});

var distinct = ["foo", "bar", 'baz"];
var csv = distinct.join("\n");

$.post(dbidTable,{
  act: "API_ImportFromCSV",
  records_csv: csv,
  clist: "6"
});