Load sub children with the new api endpoints

The new api endpoints only returns the top level of a workspace or of a folder:

As an example let's say i do that call :

https://api.smartsheet.com/2.0/workspaces/1234567890/children?maxItems=1000

It will return only the sheets, reports, folder at the root of the workspace.

(exact same behaviour for querying folders children).

If I want to look for all sheets of that folder, I'll then have to do another query for every folder and sub folder of this workspace.

Is there any plans or suggestion to avoid that overload of queries ?

Find more posts tagged with

API and Developers

Smartsheet API Deprecations

Accepted answers

All comments

jmyzk_cloudsmart_jp

@Etienne Mermillod

You can use the recursive function if you use Python, for example.

Etienne Mermillod

If I have 10 folders each one of them having 10 folders, i'll to do 100 calls to the api while currently only 1 call is required.

So in other words, that is a big regression that will force many more calls creating, a surchage on both my servers and smartsheet servers.

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.