MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.28k stars 21.47k forks source link

ERROR [HY000] [Microsoft][Zoho] (30) Error with HTTP request, response code: 400. Message: Unknown error from server". I am getting this error trying to use the Query to preview Data #99718

Closed sc-jlyma closed 2 years ago

sc-jlyma commented 2 years ago

ERROR [HY000] [Microsoft][Zoho] (30) Error with HTTP request, response code: 400. Message: Unknown error from server". I am getting this error trying to use the Query to preview Data


Document Details

Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

Naveenommi-MSFT commented 2 years ago

@sc-jlyma Thanks for your feedback! We will investigate and update as appropriate.

It would be great if you could add a screenshots or link to the documentation you are following for these steps? This would help us redirect the issue to the appropriate team. Thanks!

sc-jlyma commented 2 years ago

Hi @Naveenommi-MSFT I tried use the Query tab. I used this Scopes for Zoho: ZohoCRM.settings.all, ZohoCRM.modules.ALL, ZohoSearch.securesearch.READ, ZohoAnalytics.data.create, ZohoAnalytics.data.read, ZohoAnalytics.data.update, ZohoAnalytics.metadata.read, ZohoCRM.coql.READ

MicrosoftTeams-image (3)

Naveenommi-MSFT commented 2 years ago

@sc-jlyma could you please provide Microsoft document link which you are following, so I can help you on that.

sc-jlyma commented 2 years ago

Hi @Naveenommi-MSFT this one https://learn.microsoft.com/en-us/azure/data-factory/connector-zoho?tabs=data-factory

Naveenommi-MSFT commented 2 years ago

@sc-jlyma

The 400 (Bad Request) status code indicates that the server cannot or will not process the request because the received syntax is invalid, nonsensical, or exceeds some limitation on what the server is willing to process. It means that the request itself has somehow incorrect or corrupted and the server couldn't understand it. The server is refusing to service the request because the entity of the request is in a format not supported by the requested resource for the requested method . Therefore, it prevents the website from being properly displayed. The main thing to understand is that the 400 Bad Request error is a client-side error. The cause of a 400 error can be a wrongly written URL or a URL that contains unrecognizable characters. Another cause of the error might be an invalid or expired cookie. Also, if you try to upload a file that's too large. If the server is programmed with a file size limit, then you might encounter a 400 error.

Could you please check above things.

Naveenommi-MSFT commented 2 years ago

@sc-jlyma We are going to close this thread as resolved but if there are any further questions regarding the documentation, please tag me in your reply and we will be happy to continue the conversation.

optimo-smccarty commented 1 year ago

Was there ever any resolution to this issue or further direction provided? I am also seeking to ingest our Zoho data via Azure Data Factory. I have a linked service that connects successfully using the Zoho (Preview) connector inside of ADF and following the documents located at https://learn.microsoft.com/en-us/azure/data-factory/connector-zoho?tabs=data-factory#linked-service-properties. Despite being able to query APIs via Postman, the ADF connector continually returns a 400 error when trying to use it as detailed above in this post.

Any assistance would be appreciated.

fibronostics-juan commented 6 months ago

Same issue here. Connector seems broken. What are the alternatives to ingest Zoho data from Synapse?