Unanswered

Requires String But Is Float, How To Convert To String?

(0) Share

Report

Posted on by Slowpoke1

Wondering if anyone else has come across this issue and found a solution.

I'm trying to set up a flow that looks at a Smartsheet and when rows are updated, it updates a table in SQL Server. I'm using the Smartsheet connector and below is how the flow looks.

I'm getting the following error at the "Get a sheet data" step:

"ResponseSwaggerSchemaValidationFailure. 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/Amount' to be of type 'String' but is of type 'Float'.'"

The column in question contains all whole numbers, no blanks or nulls. When I test with a sheet that's all text everything works so it's the numbers causing this error. Would appreciate any suggestions.

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Slowpoke1

Pls try converting the value from float to string type using string() formula. For that you need to write with the formula as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Slowpoke1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the suggestion. I did see the string() formula but I'm not sure where I would use that.

This is how my flow looks, how can I wrap the string() around the values from the sheet?

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Inside the brackets you should fill in your float value (dynamic content).

Was this reply helpful? Yes No
Slowpoke1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I must be doing something wrong still. In my original flow, on step 2, I clicked on the folder icon and specified the sheet I wanted to bring in. This is the point where the flow fails because of the float.

I updated step 2 to be like below, instead of choosing the sheet from the folder icon I wrapped string() around the dynamic content "ID" (I've also tried name and body). When I run the flow with just these 2 steps, it runs successfully.

But in the SQL Update Row step, the columns from the Smartsheet no longer show up to map to a column in the SQL table. Entering the column names manually step 2 doesn't work either. The only things that populate are the metadata. (Screenshot attached).

Was this reply helpful? Yes No
Matthy79 4,188 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I don’t think that you need to convert anything. Unfortunately I don’t know Smartsheet and how it works but it seems that a schema validation failed. For some reason it thinks that the amount should be a string. Do you know where to set the schema? Have you tried to only select a view columns (and not amount) to test the api call. Does that work?

In the error message it is saying that Amount needs to be a string. Why do you convert I’d into string?

Was this reply helpful? Yes No