question

ChaitanyaSharma-5176 avatar image
0 Votes"
ChaitanyaSharma-5176 asked ChaitanyaSharma-5176 commented

Linked service for ZOHO connector in Azure data factory, Redirects not supported

Redirects not supported in Linked service for ZOHO connector in Azure data factory. It works good in the Postman

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ChaitanyaSharma-5176,

We are reaching out to the internal team to get the more details on this ask. I will be update you once I hear back from the team.

0 Votes 0 ·

@PRADEEPCHEEKATLA-MSFT ,

Thanks for informing me.

0 Votes 0 ·

Hi @PRADEEPCHEEKATLA-MSFT,

I would like to follow up for the updates on the mentioned issue.

Thanks,

0 Votes 0 ·
PratikSomaiya avatar image
1 Vote"
PratikSomaiya answered ChaitanyaSharma-5176 commented

Hello @ChaitanyaSharma-5176

The Zoho connector is still in preview mode and might lack some features that a usual connector may have

Please check the below link for available features with this connector and if you have any queries or concern(s) with this connector then you can reach out to Microsoft Support

Zoho Linked Service: https://docs.microsoft.com/en-us/azure/data-factory/connector-zoho?tabs=data-factory

Microsoft Support: https://azure.microsoft.com/support/

· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ChaitanyaSharma-5176 : Just checking if the answer helped, if yes, then can you Accept it as an Answer and Upvote it

0 Votes 0 ·

@PratikSomaiya

Thank you for sharing the thoughts. I checked the docs but didn't help.
Actually I would like to share the issue in the detail, to see if we deep dive in a bit more.

I'm using the authorization token for the leads module from the ZOHO to get the data in the Postman which works fine.
187953-image.png

however when I same thing in the ADF it give me the error
'ERROR [HY000] [Microsoft][Zoho] (1242) Redirects not supported. Server redirecting www.zohoapis.in/crm/v2/Leads/288157000000229181/crm/v2 to https://www.zohoapis.in/crm/v2/Leads/288157000000229181/crm/v2/settings/modules.
ERROR [HY000] [Microsoft][Zoho] (1242) Redirects not supported. Server redirecting www.zohoapis.in/crm/v2/Leads/288157000000229181/crm/v2 to https://www.zohoapis.in/crm/v2/Leads/288157000000229181/crm/v2/settings/modules.
Activity ID: eac7afc1-dcc2-47ef-91a1-34c755a371aa.'

187962-image.png

Tried this using Access Token method and OAuth2.0 as well, didn't work.

Let me know if I'm doing anything incorrect? [2]: /answers/storage/attachments/187546-image.png


0 Votes 0 ·
image.png (65.0 KiB)
image.png (110.6 KiB)
PratikSomaiya avatar image PratikSomaiya ChaitanyaSharma-5176 ·

@ChaitanyaSharma-5176 : Can you scrub the personal information of the Leads and again share the screenshot, Thanks

1 Vote 1 ·

@ChaitanyaSharma-5176

Thanks for explaining the issue in detail

As I read from the Zoho's documentation, they have a redirect URI which redirects you with a grant token(code) after successful authentication

Can you try using Web Activity in ADF instead of Zoho connector and see if that works

As Zoho is still in preview at ADF end, so Azure support team can help you here the best

@PRADEEPCHEEKATLA-MSFT : Can you help Chaitanya with this and see if a ticket can be created with Microsoft

But I would also recommend to check Web Activity once

Thanks

0 Votes 0 ·

Thanks @PratikSomaiya

I tried this with web activity to fetch data and REST Connector to copy into the SQL Table. and it worked.
187924-image.png

187925-image.png

I would like to connect to @PRADEEPCHEEKATLA-MSFT , to discuss the ZOHO Connector issue and see if we can dig more into it.

0 Votes 0 ·
image.png (60.8 KiB)
image.png (13.8 KiB)
PratikSomaiya avatar image PratikSomaiya ChaitanyaSharma-5176 ·

@ChaitanyaSharma-5176 : I am glad to hear Web Activity option worked, you can raise a ticket from Azure Portal for a connect with Microsoft team, as the Zoho connector is still in preview, your feedback would be very important for the product team. Additionally, if my response helped, can you Accept it as an Answer and Upvote the same. Thanks

1 Vote 1 ·
ThijsvanLith-3326 avatar image
0 Votes"
ThijsvanLith-3326 answered ThijsvanLith-3326 commented

@ChaitanyaSharma-5176 I am running into the same redirecting problems when I use the ZOHO linked service. Could you please show me how you set up the Web Activity option? That would be very much appreciated!

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@ThijsvanLith-3326 ,

For Web activity or Copy Activity using the REST connector as a source you can use, your final Endpoint and access token with the Get Method.

This will give you the data from the Zoho API.

Let me know if this helps.

0 Votes 0 ·

I see, thank you very much!

0 Votes 0 ·