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
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.
Saga over for now... :)
Thanks for the suggestions and your time.
Is anyone able to post an example? I'm trying to use the same technique, but cannot get multiple rows to read....
var text URLONE = URLRoot() & "db/" & [_DBID_ITEM_REQUESTS]
& "?a=API_ImportFromCSV&usertoken=[USER TOKEN]&apptoken=[APPTOKEN]"
&"&records_csv=<![CDATA["
&"71,Request Item for Job,1276" <---- this record will trigger
&"7,Request Item for Job,1276" <--- this one will not....
&"]]>"
&"&clist=6.44.15";
var text URLONE = URLRoot() & "db/" & [_DBID_ITEM_REQUESTS]
& "?a=API_ImportFromCSV&usertoken=[USER TOKEN]&apptoken=[APPTOKEN]"
&"&records_csv=<![CDATA["
&"71,Request Item for Job,1276" <---- this record will trigger
&"7,Request Item for Job,1276" <--- this one will not....
&"]]>"
&"&clist=6.44.15";
