ODBC-Smartsheet connector

I am trying to add smartsheet connector in User DSN through ODBC Data Source Admin.

It keeps on saying invalid username/password. I am pretty sure I am using right credentials. I can login to smartsheet with that.

We recently enabled SSO for smartsheet. I even tried User API token for SSO login. I generated the access token in smartsheet. When I enter the token, it stop responding for a while and then takes me back to "configure smartsheet datasource" screen again.

Find more posts tagged with

API and Developers

Comments

Richard Rymill SBP

Davender

No need to struggle with this there are a number of choices you need to make so best to let the Smartsheet's own support team help you with this. Once set up it worked well and very useful.

https://help.smartsheet.com/contact

RichardR

SBP

Nathan Lloyd

Hi Davender,

I would recommend verifying you're using the "Use API token for SSO login" button just beneath the Password field if you're trying to authenticate using an API Token.

If you're entering the token value into the Password field, that won't work.

If that doesn't seem to be the issue, please create a ticket with Smartsheet Support and we will be glad to assist! If you need to submit a support ticket, be sure to do so from your Smartsheet account email address so we can easily find your account information when you write in.

You can submit a support ticket here: https://help.smartsheet.com/contact

Regards,

Nathan

Smartsheet Support

odbc api token.PNG

Willem

I have already tried everything as per the above feedback and it still does not work.

Sign in to join the conversation!

Quick Links

Trending discussions

Using Control Center to Track Folder Updates?
Hello, I am unsure of the feasibility of this goal but am hoping someone could provide some insight. Within my organization we have the following structure Workspace → Workspace → Folder. Within this folder we have additional folders that are added through an API integration we have setup. I am hoping we would be able to…
Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Were there recent changes to the totalPages parameter when querying the /sheets endpoint?
Up until last week, the totalPages and totalCount parameters functioned as expected when performing a simple GET call to /sheets. If there were 150 sheets, then it would show "totalPages": 2, "totalCount": 150. As of Friday of last week, it seems like it is showing "totalPages": 1, "totalCount": 100 any time there are more…