Smartsheet从API中提取数据

询问社区,看看你们是否都找到了smartsheet目前没有的解决方案。我们正在为我们自己和我们的第三方合作伙伴建立一个API,以访问smartsheets和其他产品将从单一数据源提取的数据。ob欧宝娱乐app手机下载

然而,smartsheet没有一个解决方案从一个没有第三方系统的API PULL,你必须绕过API,直接到SQL,这是我们不想做的。另外,由于其他问题,我们无法与第三方合作伙伴共享母表。

我们已经要求smartsheet有一个自定义的API连接器,但谁知道他们是否和什么时候会建立一个,他们目前的API不允许从一个源拉数据。

有人有什么建议吗?

提前谢谢,

马克

答案

  • 理查德·里米尔SBP
    理查德·里米尔SBP ✭✭✭✭✭✭

    嗨,马克

    我们的Smartsheet顾问和开发人员团队处理过一系列类似的具有挑战性的问题,并总能找到最佳解决方案。

    如果您能和我们的CTO James Harris博士谈谈,我们就能更好地理解您的问题了。

    如果你能给我发邮件(电子邮件保护)我是首席执行官,我会为你安排的。

    只是说这将是一个免费的初步咨询,如果我们不能解决这个问题,我会非常惊讶。

    问候

    理查德。

In case anyone finds this thread, I posted this to stackoverflow and received this answer:<\/p>
\n \n https:\/\/stackoverflow.com\/a\/73194270\/6770704\n <\/a>\n<\/div>


<\/p>

Apparently in the OperationErrorResult class, there are a few errors which undergo an auto-retry:<\/p>

4003: {\n    'name': 'RateLimitExceededError',\n    'recommendation': ('Retry using exponential backoff. Hint: '\n                       'Reduce the rate at which you are sending '\n                       'requests.'),\n    'should_retry': True},\n<\/pre>

So the error is handled and the request is automatically retried.<\/p>


<\/p>

If anyone wishes for further details, please see the linked post to stackoverflow<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-02 11:49:33","updateUser":{"userID":150873,"name":"I_B","url":"https:\/\/community.smartsheet.com\/profile\/I_B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-02T11:45:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"API Developers","name":"API and Developers"}]},{"discussionID":93567,"type":"question","name":"Is there a change log for the Smartsheet API Reference?","excerpt":"The Smartsheet API Reference shows that it was updated on 2022-07-13. Is there a way to see what changed?","categoryID":320,"dateInserted":"2022-07-25T17:55:57+00:00","dateUpdated":null,"dateLastComment":"2022-07-26T14:20:48+00:00","insertUserID":127476,"insertUser":{"userID":127476,"name":"Leibel Shuchat","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20Shuchat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T14:11:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":127476,"lastUser":{"userID":127476,"name":"Leibel Shuchat","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20Shuchat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T14:11:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3317618205,"url":"https:\/\/community.smartsheet.com\/discussion\/93567\/is-there-a-change-log-for-the-smartsheet-api-reference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93567\/is-there-a-change-log-for-the-smartsheet-api-reference","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":93567,"commentID":337455,"name":"Re: Is there a change log for the Smartsheet API Reference?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/337455#Comment_337455","dateInserted":"2022-07-26T14:20:48+00:00","insertUserID":127476,"insertUser":{"userID":127476,"name":"Leibel Shuchat","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20Shuchat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T14:11:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-26T14:20:50+00:00","dateAnswered":"2022-07-26T12:18:44+00:00","acceptedAnswers":[{"commentID":337424,"body":"

Hi,<\/p>

I checked with and older version of the swagger documentation from the API reference: the changes are mostly typos.<\/p>

there are also some changes regarding the commenter level access on reports and notes about the US-GOV version of smartsheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-07-26 14:20:50","updateUser":{"userID":127476,"name":"Leibel Shuchat","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20Shuchat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T14:11:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":227,"urlcode":"API Developers","name":"API and Developers"}]},{"discussionID":92735,"type":"question","name":"Python get_columns response.","excerpt":"I am trying to find specific columns through the python api. Running something like listColumns = smartAPI.Sheets.get_columns(83053825###, include_all=True) gives me the object and not the Field Name. [, Hey @MikeG_O<\/a> <\/p>

It looks like you may just need to resolve the response (i.e. columns = listColumns.data<\/code>). Here's the API Documentation and example: List Columns<\/a><\/p>

Let me know if this has helped!<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-07-06 16:35:25","updateUser":{"userID":149319,"name":"MikeG_O","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MikeG_O","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-07-19T16:04:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">