Unanswered

Smartsheet to Google Sheets

(0) Share

Report

Posted on by colinswaim98

Hello,

I am trying to copy Smartsheet data to google sheets for additional analysis. My eventual plan is to clear the google sheet and copy the smartsheet data. While building this, I got the following error message and I am not sure what it means.

I have been able to do this for certain columns in my smartsheet, but when I add other columns it fails. Thanks for any help!

"The API 'smartsheet' returned an invalid response for workflow operation 'Get_a_sheet_data_(dynamic_schema)' of type 'OpenApiConnection'. Error details: 'The API operation 'GetSheetData' requires the property 'body/value/0/Job Number' to be of type 'String' but is of type 'Float'.'"

Screenshot 2021-08-31 150345.png

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,598 Most Valuable Professional on at

Like (0)

Report

Re: Smartsheet to Google Sheets

Hi @colinswaim98

I did tried with a numeric column and it did worked as expected. What's your data type for Job Number? Not sure why you getting this error. Could you remove this step and add it again?

Thanks

Was this reply helpful? Yes No
colinswaim98 2 on at

Like (0)

Report

Re: Smartsheet to Google Sheets

Thanks so much for your response! The job number column is the primary column so the data type is text/number.

Was this reply helpful? Yes No
abm abm 32,598 Most Valuable Professional on at

Like (0)

Report

Re: Smartsheet to Google Sheets

Hi @colinswaim98

Thanks for you reply. I just tested with text/number and it did worked for me. Could you create another test sheet and try. Just want to rule out are there anything specific for your specific smartsheet having issues.

Thanks

Was this reply helpful? Yes No