My apologies for the late reply.
It seems like you are trying to call the API using GET method from your excel (I believe it’s Power Query?).
But the supported method is only ‘POST’ at the moment where you have to pass the ‘url’ in the request body.
If you don’t mind, could you please share a copy of the Excel sheet?
Please remove any sensitive data and API key from it before sharing.
I am happy to create an Excel sheet for you where you can call the API using the POST method.
And there are not response, because this is not connecting… what are you meaning?
Can you show me an excel set up example worked?
I need the API can be called from excel…
Hi @Viskaviska,
My apologies for the late reply.
It seems like you are trying to call the API using GET method from your excel (I believe it’s Power Query?).
But the supported method is only ‘POST’ at the moment where you have to pass the ‘url’ in the request body.
If you don’t mind, could you please share a copy of the Excel sheet?
Please remove any sensitive data and API key from it before sharing.
I am happy to create an Excel sheet for you where you can call the API using the POST method.
Thanks!
Maybe you meaning the error text returned. Is this:
Details: “Web.Contents failed to get contents from ‘https://ahrefs-dr-rank-checker.p.rapidapi.com/check?url=google.com’ (404): Not Found”
Hi, you can see the set up in the image: https://ibb.co/q5zw7g1
And there are not response, because this is not connecting… what are you meaning?
Can you show me an excel set up example worked?
I need the API can be called from excel…
Than you.
Hi,
Sorry, you are facing issues with Excel setup.
Can you please tell me what you are getting in the API response?
Thanks.
the image:
https://ibb.co/q5zw7g1