Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX - REST Data Source - Bearer Token - PaychexFlex

User_C5U07Jan 18 2023

Hello Everyone,
I am fairly new to APEX/PLSQL and have been struggling to establish a connection with PaychexFlex for a few weeks now and would really appreciate any guidance provided.
The goal: Establish a connection with PaychexFlex to fetch company records to populate tables within our APEX instance.
Error(s): Bearer token is expired or invalid.
Background: I've attempted many times to create a Simple HTTP or Oracle Rest Data Services REST Data Sources using the REST Data Sources option within Shared Components. I populate the endpoint URL as requested 'https://api.paychex.com/companies'. I continue to the Authentication screen where I've tried 'OAuth2 Client Credentials Flow' and 'Basic Authentication' and provided the OAuth URL, Client ID & Client Secret, then click discover.
When I click discover, I receive the error that the Bearer Token is expired or invalid.
image.pngI've been able to successfully retrieve the data from Postman and SoapUI using the same credentials without issues, so I'm really lost on where to go from here. Any advice, tips, tricks, anything at all would be extremely helpful at this point.
Please let me know if you have any input or follow-up questions, and I do my best to answer them the best I can.
Thank you in advance - T

Comments
Post Details
Added on Jan 18 2023
8 comments
2,531 views