Unable to pull data from google sheets

Dear Team,

I have a google sheet with data:

username closingstock
abc 12000
def 13000
ghi 14000

I want to get the data of closingstock for a specific username which will be entered in the previous question in KOBO form. I want to display this pulled data in a question next to that.

the syntax I used is

pulldata(‘https://docs.google.com/spreadsheets/d/e/2PACX-1vREEKR26T_yIhvaAFRLIRFEg0SpmGnjLbrjmjMNhOKzvpV9sK-_cZPBAhEZ0EDexa3ajm-7sj2Jp_lV/pub?output=csv’,‘closingstock’,‘username’,'abc’)

But I am getting this error

image.png

The actual work is below:

The username will be entered in the ‘Partner’ question.

Please help me with this

Dear Team,

I have a google sheet with data:

username closingstock
abc 12000
def 13000
ghi 14000

I want to get the data of closingstock for a specific username which will be entered in the previous question in KOBO form. I want to display this pulled data in a question next to that.

the syntax I used is

pulldata(‘https://docs.google.com/spreadsheets/d/e/2PACX-1vREEKR26T_yIhvaAFRLIRFEg0SpmGnjLbrjmjMNhOKzvpV9sK-_cZPBAhEZ0EDexa3ajm-7sj2Jp_lV/pub?output=csv’,‘closingstock’,‘username’,'abc’)

But I am getting this error

Please help me with this

Please, avoid posting your same issue twice, see https://community.kobotoolbox.org/t/loading-error-when-pulling-data-from-google-sheets/51242. Would you mind to delete one of the two (… menu below the post), please?

Hint: You can edit a post if needed.

1 Like

@SwethaShri, try using the CSV file instead of the google sheet link and that should solve your issue.

Hi thank you for the immediate response and apologies for multiple posting and also thank you for identifying and removing that. The thing is that the data from the google sheets is dynamic. I am getting data from the form and feeding it in google sheet using API connector. From that I am calculating a value ( an integer) and storing it in a g sheet. These are all automated. Now I need to pull this calculated value into the form. This is actually a stock register and I’m trying this workaround to get the closing stock of last day. If you suggest another way to achieve this that will also be great.

Can you also tell us which server you are using, please?

1 Like

I’m using kf.kobotoolbox.org

@Kal_Lam please support

@wroos please support