Skip to main content
  • EN

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

 

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


 

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


Community Stats

30,351
Posts
115,336
Replies
38,078
Members
Terms & ConditionsCookie 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.