Chains Array to CSV File ID too Big
답변함Hello,
I'm using an HTTP Connector to load the data into Wdata table. My 'Create File' output is succesfully being loaded intot the Wdesk Spreadsheet however I run into error trying to load the same file into the Wdata table saying 'fileId size must be between 0 and 32 Code 400'.
Is there a way to update the File Id to shorter ID?
Please refer to the screenshot below.
Thanks,
Bharath G
-
Hi Bharath Goolla,
You're getting this error because you have passed in a file rather than a valid file ID. When the Create File node is successful, it will return the ID of the file created in the Wdata Table. This ID can then be used in the Import File Into Table command.
I recommend going through the CLP - Uploading Data to a Table guide to better understand how this works. I also recommend using the Load Data to Wdata template rather than building your own similar logic when possible.
0
Thank you Jeff Hickey,
I had to use the Change Delimeter node and was able to successfully load the data into the Wdata table.
Do you also have any pointers on how to keep the HTTP nodes running in iterative mode for queries with huge number of rows? I got about 1M rows.
Thanks,
Bharath G0댓글을 남기려면 로그인하세요.
댓글
댓글 2개