Hi
I tried to use it inside my google sheet document but am getting this error
Exception: Request failed for https://tafqit.p.rapidapi.com returned code 400 (line 20).
and here is the code I wrote
function Taqfeet(input){
const encodedParams = {
“the_number”: input,
“unit”: " ريال سعودي",
“hundreds_form”: “مائة”
}
const options = {
method: ‘POST’,
headers: {
‘content-type’: ‘application/x-www-form-urlencoded’,
‘X-RapidAPI-Key’: 'here the key I got after subscriping,
‘X-RapidAPI-Host’: ‘tafqit.p.rapidapi.com’
},
body: encodedParams
};
var response = UrlFetchApp.fetch(‘https://tafqit.p.rapidapi.com/convert’, options)
.then(response => response.json())
.then(response => console.log(response))
.catch(err => console.error(err));
}
चर्चा में शामिल हों - नीचे टिप्पणी जोड़ें:
Hi,
Sorry I don’t have experience with Google sheets…will need some time to check this.
can you please look into these, and see if they can be of any help
https://stackoverflow.com/questions/60118158/request-failed-returned-code-400-truncated-server-response-google-scripts
https://stackoverflow.com/questions/70891608/exception-request-failed-returned-code-400-french
https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app
Thanks
Sami