Is it possible to create bulk/multiple sheets using Create Sheet API in a single call?

FYI: I am aware of looping the request to create multiple sheets, but how can I perform bulk creation within a single call?

Please help me with knowing how to achieve this. The response schema in the API documentation allows me to think bulk operation on "https://api.smartsheet.com/2.0/sheets" endpoint is possible as it shows success and partial success as well.

However the request body demonstrates only a single sheet creation.

Thank you in advance.

Find more posts tagged with

Sheets

API and Developers

Accepted answers

All comments

Genevieve P.

Hi @nishikamanira

I don't believe there's a way to create multiple sheets at one time using a bulk operation and an array within the Post > Create Sheet.

The resultCode portion here that you see lists standard response possibilities for the POST method. The possible result codes overall are success or partial success, however partial success may not be a possibility for every endpoint. Here's more information on Bulk Operations.

I would suggest looping the request as you noted.

Cheers,

Genevieve

nishikamanira

Thank you @Genevieve P. for the elaborate answer. It definitely helped in clearing out my query.

Thanks,

Have a nice day.

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.