Smartsheet to Oracle Enterprise Data Quality - OAuth2 Client Credentials

Hello Everyone-

I am attempting to connect Smartsheet to Oracle's EDQ and keep running into the error "Process Failed: Network error OAuth2: error in access token request: Tried all" 6 addresses, but could not connect over HTTPS to server: api.smartsheet.com port:443 (Code 320,003)"

I have tried different combinations of credentials, and we are just mixing up what is being required, but I have tried following the OAuth guide. I already registered for Developer Tools and created an app using one of my sheets for testing this connection. (Which I would have just liked to link it to the sheet using the Sheet ID, but made an App) From the developer Tools, I was given the App Client ID and App secret. But I am unsure of the Scope to enter (all the other scopes for APIs have a lot more "verbiage" than what is shown in the Smartsheet help document), and I am assuming for the token Request URL, I had it as https://api.smartsheet.com/2.0/tokenError, but I'm not sure if it should be App URL.

Any help in pointing me in the right direction to get these two systems to start talking to each would be much appreciated 🤞

Find more posts tagged with

Accepted answers

All comments

Isaac A.

Hi @Kevin Schaller!

I haven't personally worked on an integration between Smartsheet and Oracle EDQ, but hopefully, someone else in the Community has experience with this specific setup and can chime in!

In the meantime, since this involves troubleshooting both the Smartsheet API and the Oracle configuration, I would recommend posting your question in these developer communities as well to get more targeted help:

Stack Overflow: You can post under the Smartsheet API tag here: https://stackoverflow.com/questions/tagged/smartsheet-api
Oracle Community: You can check the Enterprise Data Quality discussion board here: https://community.oracle.com/customerconnect/discussions/tagged/225-enterprise-data-quality/p1

If you do find the solution, please share it here so others running into the same error can benefit from it too.

Thank you!

Cheers,
Isaac.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.