API_ImportFromCSV duplicate key
I am using the API_ImportFromCSV to load data from an external system into QB but it is giving me an error: Trying to add a non-unique value to a field marked unique. https://fixandpaint.quickbas...
Forum Discussion
Get rid of the "<![CDATA[" and "]]>" and include explicit newlines in the URL. Slightly reformulated try this instead:
Notes:
(1) Normally API_ImportFromCSV is not called as a GET method as there is a limit on how long a URL can be and the CSV data can be quite long.
(2) I am not sure why you are using a user token when you have a application token and presumably the user is already logged in.
(3) Your formulas will be more readable if you lay it out with one parameter line value per line and continue the line with an ampersand at the end.
(4) Note there is a newline character at the end of the first line of the CSV.
var text URLONE = URLRoot() &
"db/" &
[_DBID_ITEM_REQUESTS] &
"?a=API_ImportFromCSV" &
"&usertoken=<USER TOKEN>" &
"&apptoken=<APPTOKEN>" &
"&records_csv=" &
"71,Request Item for Job,1276\n" &
"7,Request Item for Job,1276" &
"&clist=6.44.15";
Notes:
(1) Normally API_ImportFromCSV is not called as a GET method as there is a limit on how long a URL can be and the CSV data can be quite long.
(2) I am not sure why you are using a user token when you have a application token and presumably the user is already logged in.
(3) Your formulas will be more readable if you lay it out with one parameter line value per line and continue the line with an ampersand at the end.
(4) Note there is a newline character at the end of the first line of the CSV.