Skip to main content

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