Forum Discussion

Qrew Cadet

Re: API_ImportfromCSV doing nothing

So I can't say for sure about your google scripts example without seeing your array for arregloGuias - but in your first URL example - you have the skipfirst=1 meaning you're skipping the first row, but you only have 1 row so it's not going to import anything. The skipfirst is usually intended if you have headers. Remove that from your first example and that should get you moving

Side note - your clist only has one field (clist=6) but it looks like you're trying to import to 3 fields (records_csv=Guia,34168,102999). You'll want to make your clist have 3 field IDs to match

6 Replies

CarlosCarlos
Qrew Assistant Captain
6 years ago
Hi Chayce,
I actually have a single column (Guia) that is being imported, and the 2 values there (34168 and 102999) are 2 records that should be created, importing into fid_6. Though currently only 2 values/new records, this could be any number of records, but always a single value will create them.

The array would look something like [34168,102999] with N number of values possibly in there. I'm manually adding the "Guia" header, though that could be removed.
ChayceDuncan2
Qrew Cadet
6 years ago
Ah - now I see what you're doing. So then same reason - different explanation from my first comment. Since its an importFromCSV - you have to force it to understand a new row. By doing value,value 2,value 3 as comma delimited - your browser just treats that as 1 row.

So you'll want something like this:

"https://yourrealm.quickbase.com/db/yourtable?a=API_ImportFromCSV&records_csv=Guia" & URLEncode("\n") & "row1" & URLEncode("\n") & "row2" & "clist=12"

The URLEncode if you're in QB will force it to interpret them as new lines. You can leave or remove the skipfirst at that point
CarlosCarlos
Qrew Assistant Captain
6 years ago
Well that seems to have done the trick nicely!!

I'd like to get it to work without using the URL alternative, basically so an unlimited number of records could be posted at any given time, but this will definitely do for now!

Thanks a lot!