Help populating Make API Call module for Smartsheet

ForgeAhead

I am not able to correctly populate the Make API Call Module for Smartsheet

• I have established a connection with Smartsheet.
• I have created a trigger that activates when a new attachment is added in Smartsheet (and it works). For my purposes I am adding an attachment to a row.
• I have connected the Make API Call module to the trigger
• I read the API documentation on Smartsheets for how to get an attachment
• I have read the API documentation on Smartsheet to authenticate the call
• I have admin permissions on Smartsheet
• I have my API key

I cannot figure out how to populate this module so that it makes the correct API call.

Please Help!

Brian_Richardson

This isn't a Smartsheet app that you're showing. What tool is this?

Are you using OAuth to authenticate to Smartsheet? Because if not you need to add an Authorization header using a token that you get from your Personal Settings area of Smartsheet, like this: Authorization: Bearer token id

ForgeAhead

@Brian_Richardson, this is using make.com (formerly integromat).

I am trying to authenticate using an API Token. I have added the API key from my personal settings area.

Here is my most recent API call using Make:

This returned

[

null

]

and an error code Not Found (error code: 1006, ref ID: xsgfwn)

Thanks for any help.

Brian_Richardson

Although the "pieces" are here, it's a little odd to see them all wrapped up in JSON format like they are the body of a call. Is that how Make works? I'm not familiar with the tool but most IPaaS will have some kind of UI that gives you fields to enter the URL, the headers, the method, and the body. For this particular call to sheets, there is no body, and therefore you don't actually have to define Content-Type, although it doesn't hurt anything.

You have the right pieces, so I'm just wondering if they are in the wrong place inside your tool as Body rather than as the parts of your call. You can also try using Postman, it's free and allows you to make API calls to ensure you have the right info and format to successfully make the call.

For example, here's an API call to ServiceNow using Smartsheet Bridge. Note there's a URL, Method, Headers, and Body section. Body is blank. Typically there's no body for GET calls.

Ultimately, though, you have the right information to make that very basic Sheets call, so your next step should probably be to reach out to Make support to help you with their tool, because this isn't really a Smartsheet thing.