https://linen.dev logo
Join Slack
Powered by
does anyone have an update on <https://github.com/...
# singer-taps
j
does anyone have an update on https://github.com/singer-io/tap-dynamics-365?
e
Hi @Jun Pei Liang! What specifically needs to be updated about the tap? (Note that it's maintained by Stitch, but we could fork it and apply patches if necessary).
j
Hi Edgar,
We are using Microsoft Dynamics 365 CRM to store our customer information. We have created a client ID and client secret in Azure and tested with the Dataverse Connector in Microsoft Fabric, which was successful. (#1) We want to test the connection via Meltano, so we search for dynamic taps and found the following two: tap-ms-dynamics and tap-dynamic-365. Unfortunately, when using tap-ms-dynamics, we received an error (#2), despite entering our client ID and client secret, and oraganization_uri correctly. It looks like it is requesting fields such as 'start_date', 'user_agent', 'redirect_uri', and 'refresh_token', but these are not required when we tested in Fabric. Then, we looked into tap-dynamic-365 but it seems it is still under development.
screesshot1
screenshot2
@Edgar Ramírez (Arch.dev) please find my feedback above
e
despite entering our client ID and client secret, and oraganization_uri correctly. It looks like it is requesting fields such as 'start_date', 'user_agent', 'redirect_uri', and 'refresh_token',
Ok, so • 
start_date
you just need to set it to some value, e.g. 
2024-01-01
• 
user_agent
similarly, e.g. 
Meltano
redirect_uri
and 
refresh_token
are a different story. Most likely Fabric has these saved internally for its own application. In this case, you'll have to register your own Microsoft Dynamics 365 CRM oauth application. There should be docs for that.
j
@Edgar Ramírez (Arch.dev) registration part has been done. but i couldn't find the right doc to get 
refresh_token
and 
redirect_uri
right. Any advise?
e
Which docs did you follow to register the app?
j
@Edgar Ramírez (Arch.dev) i am able create connection after hours of testing. The redirect_uri has to match what i configure in Azure App Registration (e.g. http://localhost) and we have consent the app registration to have have offline access, then you use authorization code to retrieve the refresh_token.
🙌 1
@Edgar Ramírez (Arch.dev) sorry to bother you again. i try to extract data from dynamic to csv, but no data exported.
looks like it only get modifiedon ge 2025-01-28, but how can i get the inital?
e
You're using tap-ms-dynamics. correct?
j
there different tap=dynamics, but im using singer-io variant
e
Did you configure the 
start_date
?
j
yes i changed it older date: - name: tap-dynamics variant: singer-io pip_url: git+https://github.com/singer-io/tap-ms-dynamics.git config: organization_uri: https://xxxx.crm.dynamics.com redirect_uri: http://localhost api_version: '9.2' start_date: '2022-01-01' user_agent: meltano select: - mps_endproductofinterest.*
e
Ok, try running again with 
--full-refresh
j
yes, that work
thank you
4 Views
Open in Slack
PreviousNext
Powered by