API_ImportFromCSV duplicate key

Double check the field properties for all the fields involved in the import and make sure that non of them are requiring unique values.

Then you might be able see the error in the import.

Thanks Matthew, the only field that is unique is 6, which is the key

Dean,
Was that your actual URL? Are you just adding 1 record or is it possible that the data in the actual import set has a duplicate Key in multiple records.

That is the actual URL. I originally had more data but reduced it to one row for debugging

I did not run it through urlencode. Might that make a difference?

Btw. This same process creates an output file and I can import using the ui just fine. Inserts and updates both work as expected.

I did not go back to the documentation, but I wonder if there is a syntax error and in fact there is not a duplicate key but some kind of syntax error in the URL.

The solution involved adding a carriage return after each data row ("'r'n ").  Then I had issues with strings, but encapsulating them in double quotes fixed that.

Saga over for now... :)

Thanks for the suggestions and your time.

Get rid of the "<![CDATA[" and "]]>" and include explicit newlines in the URL. Slightly reformulated try this instead:

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.