Error "propertyType is required" when calling Idealista API with Azure Synapse Analytics

Question

When I configure a Source Dataset with a REST linked service in Azure Synapse Analytics to call the Idealista API, which is based on OAuth 2.0 authentication and some input parameters, I receive the following error:

Rest call failed with client error, status code 400 BadRequest, please check your activity settings.
Request URL: https://api.idealista.com/3.5/es/search.
Response: {"message":"propertyType is required","httpStatus":400}

I think it believes that a propertyType is missing, which is required in the input parameters according to the error message, but I think I have configured the headers and params of the call correctly... what could be happening? I have no problem with Postman.

Please see screenshots of the configurations

With Postman there is no problem otherwise

Answer 1

Verify if the propertyType parameter is being included in the body or query string of the request exactly as the API expects it and then check that the OAuth 2.0 authentication is working correctly within Synapse. Since it's working on Postman, there might be an issue with how the token is being used or generated in Synapse.

If you are sending the propertyType in the body of a POST request, make sure the Content-Type header is set correctly ( application/json or application/x-www-form-urlencoded)

Answer 2

Hi CARLOS LOPEZ JUAN,

Thank you for posting query in Microsoft Q&A Platform

It seems request is not getting made correctly. I observe that instead of request body you created parameters in dataset and passing values to them. Please note, dataset parameters will not go as request body. Kindly consider writing request body json in the request body file under copy activity source tab.

Hope this helps. Please let me know how it goes.

---

Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.

Answer 3

Any help please?