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.

Find more posts tagged with

API and Developers

Accepted answers

All comments

Paul Newcome

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).

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.