Skip to main content
Question

Setting up a web connection in FME Workbench with OAuth2

joshuajames1979
Contributor
Forum|alt.badge.img+7

Hi there, we are looking at making an OAuth2 connection so that we can pull back JSON files from our Asset Management System in TechOne so that we can then populate our SQL data. I thought FME Workbench would be a lot cleaner than using Python, however I am struggling to connect when setting up a web connection. I receive “an error has occurred” when testing. Out of the three requirements I am unable to set the third one, which is most important. This being grant_type in the body needs to be set to “client_credentials”. Is there any way to change this? I read that you can’t so trying to see if there is a workaround.

I read online some are suggesting a REST API but not sure if that’s the way to go in FME Workbench.

Regards,

Josh

 

db23451
1 person upvoted this
  • db23451
    db23451

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+53
  • hkingsburyCelebrity
  • Celebrity
  • March 6, 2024

Is OAuth2 the only authentication method the service provides? 

Looking at the configuration of a new OAuth2 connection, do does say that the grant_type is authorization_code. I wonder if specify grant_type as client_credentials will override that


 

db23451
1 person upvoted this
  • db23451
    db23451
db23451
Contributor
Forum|alt.badge.img+1
  • db23451Contributor
  • Contributor
  • July 12, 2024

Hi,

Did you get the Web Connection to work with TechOne (I’m in the same place and you DenverCoder9’d me)?

I know it’s not their end as I currently successfully read it through PowerShell, but want to try it in FME.

Thanks

David

Update: I found a way around it, it’s not elegant but it works - I’ll hopefully have time to go back and fix it in the future when I understand FME better.

Temporary solution:

  1. A HTTPCaller to send the POST request to retrieve the token
  2. A SubstringExtractor and AttributeManager to parse out the token code
  3. A second HTTPCaller to send the GET request to retrieve the JSON


 

Reply


Helpful Members This Week

Community Stats

31,137
Posts
118,053
Replies
38,779
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.