|
Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Chains Array to CSV File ID too Big

Request Demo

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

0

Comments

2 comments

Date Votes
  • Jeff Hickey

    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
  • Bharath Goolla

    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 G

    0

Please sign in to leave a comment.