Survey Monkey-Matillion Manage OAUth Issue

Matillion ETL
1

Hello experts,

I have designed an ETL pipeline using survey monkey inbuilt query component and manage oauth configuration to extract the data.

 

I have encountered SURVEYMONKEY Oauth issue during the production deployment while setting up OAuth with the application's client ID and secret. The authorization process is completed, but the service response continues to render indefinitely.

 

During development, I was able to successfully configure the connections through "Matillion" OAuth using the client ID and secret. However, I am currently unable to configure the authentication with Survey Monkey neither in dev nor in other instances anymore.

 

Followed all of the options I could to resolve this issue from my side but no luck:

  • Tested in incognito/private mode but same message.
  • Tried generating new credentials but it kept rendering.
  • callback DEV & PROD URLs are present in survey monkey configuration
  • checked with  Survey Monkey's , no changes have been made from their end
  • sent out server logs and detail information to Matillion support team, but they are not able to find the root cause yet.
  • Tested with Python and postman to check 200 response with token and its succeeded.

I would greatly appreciate if it anyone could provide advice reg this issue. Thank you in advance.

2

@Bryan​ @Michael​ Please advise

3

Hello Data Eng.

 

This appears to be a bug. I was also able to reproduce it.

The OAuth flow is authenticating correctly, however it appears the response isn't being returned to Matillion.

May I ask that you log a support ticket with our team via support.matillion.com and we will look into this.

 

Regards

Ben Smiles

Matillion Product Team

4

Hello,

I have encountered the same issue. But even after trying the provided workaround Matillion is still stuck at "Waiting for response from service". Could you elaborate on what all steps you followed which made it work, may be I am missing something.

Thanks.

5

Thanks to Matillion tech team. 

 The problem was identified to be related to Matillion's JDBC drivers.

 However, they have provided us with a workaround that allows us to handle the problem for  now.

0694G00000Usb1pQAB_0D74G000008B2zeSAC
0694G00000Usb1pQAB_0D74G000008B2zeSAC1000×233 6.07 KB

6

Hi @sdhall​

Sorry to hear you have an issue with this, It does seem a chat with our support team may be needed as per the previous replies on this thread if you raise a case here they will be able to look into this for you.

Please do share your solution with us here.

Kind regards, Joe