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

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
colinswaim98 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for your response! The job number column is the primary column so the data type is text/number.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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