zayesh
September 24, 2024, 6:10am
1
While trying to run a download of the data thru an API connector we are getting the following message: (this runs in Google Sheets)
Exception: Request failed for https://kc.humanitarianresponse.info returned code 500. Truncated server response:
<meta name=“viewport” content="initial-scale=1, maximum-scale=1, user-sca… (use muteHttpExceptions option to examine full response)
Please assist
Hi @zayesh and welcome back,
This post might help you:
Goodday,
While trying to run a download of the data thru an API connector we are getting the following message: (this runs in Google Sheets)
Exception: Request failed for https://kc.humanitarianresponse.info returned code 500. Truncated server response:
<meta name="viewport" content="initial-scale=1, maximum-scale=1, user-sca... (use muteHttpExceptions option to examine full response).
at getResponseText_(Code:135:32)
at gsImportNew_(Code:41:23)
at gsImportNew(Code:34:10)
<p>It has been w…
EDIT: changed the link to the correct one
zayesh
September 26, 2024, 9:41am
3
I cannot find any solution over there. Can you please point exact link where I can get the solution?
zayesh
September 26, 2024, 9:46am
4
Dear sir,
I have a problem while trying to a download the data reside in kobo via API token in google sheets. This was running smoothly but since a couple of day it generates error in Google Sheet like below:
Exception: Request failed for https://kc.humanitarianresponse.info returned code 500. Truncated server response: …
Can you please address my issue? I will be very thankful
Hi @zayesh so sorry, I edited the reply to include the correct post right now.
1 Like
Kal_Lam
September 26, 2024, 3:59pm
6
@zayesh , are you using API V1
for this? If yes, please try API V2
to see how it behaves.
zayesh
September 27, 2024, 3:59am
7
Its still not working @Kal_Lam . I am using google scripts to import data from the kobo via this script links GitHub - pcurrier/KoboToolbox-GoogleApps-Scripts: Google apps scripts for copying data between KoboToolbox survey and Google sheet . It was working fine for all forms but now some forms have such issues during download. Can you please suggest? Thank you!