Smartsheet是否支持一个API来获取模板的头名称?

罗山
罗山 ✭
在API和开发人员

我想进行一个API调用，以获取用户创建的模板的列名和各自的数据类型。

标签:

答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理

    嗨@Roshan

    可以使用Get Template检索可以访问的用户创建的模板列表。看到的:用户创建的模板列表API文档中。

    这将告诉您模板的所有名称，但对象不包括每个模板中的列名或列类型。为了获得这些数据，我将从模板创建一个Sheet，然后使用得到表。

    欢呼,

    吉纳维芙

类别

Hi @DR Brian<\/a> <\/p>

I haven't worked with Boomi before, but it sounds like you may want to post in their Community for some API guidance. <\/p>

I found this other thread that may help: Webhook<\/a><\/p>

Here's the Boomi documentation on API security<\/a>.<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-13 07:38:57","updateUser":{"userID":150887,"name":"DR Brian","title":"","url":"https:\/\/community.smartsheet.com\/profile\/DR%20Brian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AItbvmkBuYrYPbdemTi50CFt1xzprFTHWzyp_P53iLS4=s96-c","dateLastActive":"2022-09-13T07:38:19+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":[]},{"discussionID":95033,"type":"question","name":"Simple row update via API\/Powershell","excerpt":"Just getting started with the API. Just want to show a proof of concept of updating a cell. I'm able to authenticate and get sheet, row and column details. I'm getting the error: Invoke-RestMethod : { \"errorCode\" : 1008, \"message\" : \"Unable to parse request. The following error occurred: Unrecognized token 'value': was…","categoryID":320,"dateInserted":"2022-09-02T20:33:46+00:00","dateUpdated":null,"dateLastComment":"2022-09-06T12:36:36+00:00","insertUserID":152036,"insertUser":{"userID":152036,"name":"DarylVogan","url":"https:\/\/community.smartsheet.com\/profile\/DarylVogan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-15T15:55:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-22T23:12:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":95,"score":null,"hot":3324620422,"url":"https:\/\/community.smartsheet.com\/discussion\/95033\/simple-row-update-via-api-powershell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95033\/simple-row-update-via-api-powershell","format":"Rich","tagIDs":[438],"lastPost":{"discussionID":95033,"commentID":342458,"name":"Re: Simple row update via API\/Powershell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342458#Comment_342458","dateInserted":"2022-09-06T12:36:36+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-22T23:12:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-09-06T12:36:11+00:00","dateAnswered":"2022-09-06T12:35:21+00:00","acceptedAnswers":[{"commentID":342457,"body":"

Thanks. Fresh eyes and coffee helped out. Got it working. For those that may run into this:<\/p>

$uri=\"https:\/\/api.smartsheet.com\/2.0\/sheets\/aaaaaaaaaaaaaa\/rows\"<\/a><\/p>

$body = '[{\"id\": \"rowid\", \"cells\": [{\"columnId\": yyyyyy,\"value\": \"zzzzzz\"}]}]'<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-06 12:36:11","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-22T23:12:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":438,"urlcode":"api-developers","name":"API Developers"}]},{"discussionID":95018,"type":"question","name":"get_report in Python API not returning all rows when no page \/ pagesize specified","excerpt":"I don't think I used to run into this issues but when using the Python SDK I'm getting an index out of range when looping though the report object returned by get_report when it is called without a page and pageSize: Example code: # Modules import sys import smartsheet import pprint #static details SourceReportID =…","categoryID":320,"dateInserted":"2022-09-02T15:10:37+00:00","dateUpdated":null,"dateLastComment":"2022-09-06T11:51:38+00:00","insertUserID":144495,"insertUser":{"userID":144495,"name":"Ryfrank","url":"https:\/\/community.smartsheet.com\/profile\/Ryfrank","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T15:26:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-22T23:12:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":40,"score":null,"hot":3324597135,"url":"https:\/\/community.smartsheet.com\/discussion\/95018\/get-report-in-python-api-not-returning-all-rows-when-no-page-pagesize-specified","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95018\/get-report-in-python-api-not-returning-all-rows-when-no-page-pagesize-specified","format":"Rich","tagIDs":[227],"lastPost":{"discussionID":95018,"commentID":342448,"name":"Re: get_report in Python API not returning all rows when no page \/ pagesize specified","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342448#Comment_342448","dateInserted":"2022-09-06T11:51:38+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-22T23:12:40+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/3M9S6BA80FMW\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-06T12:31:33+00:00","dateAnswered":"2022-09-06T11:51:38+00:00","acceptedAnswers":[{"commentID":342448,"body":"

Hi @Ryfrank<\/a> <\/p>

You are correct that the default is 100, which is why you're receiving the error. The default is set to 100 even if no pageSize or page is specified: I would recommend setting paging into your request. <\/p>

I will also submit feedback to the documentation team that there's an additional sentence in the pageSize text that's incorrect, thank you! (You can see it talks about returning rows from a Sheet<\/em>, but this request is for a Report). <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-06 12:31:33","updateUser":{"userID":144495,"name":"Ryfrank","url":"https:\/\/community.smartsheet.com\/profile\/Ryfrank","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-22T15:26:02+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"}]}],"title":"Trending in API & Developers","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">