API data transfer error. HELP!
I am trying to do a transfer of data from a CSV file to an existing smartsheet. Because I need to import 167K rows, I want to do it programmatically. The script seems to work for a bit, but then I get an error that I can't seem to resolve.
Here's the error I am getting:
{"response": {"statusCode": 400, "reason": "Bad Request", "content": {"errorCode": 1008, "message": "Unable to parse request.", "refId": "5fc28681-d5a0-4f02-82dc-0f04ed858217"}}}
I can't seem to find anything wrong with the data. The mapping of the columns and the data types are good.
Any thoughts or suggestions? I am stumped.
Answers
-
The most immediate issue I can see would be that there are sheet limitations. 20,000 rows, 400 columns, or 500,000 cells (whichever gets met first). Anything beyond that would require multiple sheets.
There are also limits as to how many rows can be imported at once (500 per call) and how many requests can be made per minute per key (300).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives