I am currently using a dataflow within ADF to source data from smartsheets into a sql db. 1 of the Smartsheet source columns issue is experienced on, datatype text: Source Data in smartsheets: Data as previewed from dataflow: Issue on a different column, Smartsheets: ADF Dataflow preview:

ADF Smartsheets connector incorrectly converts data when sourcing

TyroneM 5

I am currently using a dataflow within ADF to source data from smartsheets into a sql db.

1 of the Smartsheet source columns issue is experienced on, datatype text:
User's image

Source Data in smartsheets:
User's image

Data as previewed from dataflow:
User's image

Issue on a different column,

Smartsheets:
User's image

ADF Dataflow preview:
User's image

AnnuKumari-MSFT 33,721 Reputation points Microsoft Employee

2023-05-25T09:17:32.06+00:00

Hi TyroneM ,

Welcome to Microsoft Q&A platform and thanks for posting your query here.

As I understand your issue, while trying to use smartsheet connector in ADF Dataflow, some of the source records which are coming as a different datatype also, blank records is getting skipped while previewing the data. Is that the correct understanding?

Did you try using 'Overwrite schema' under projection tab of source transformation to change the datatype to 'string'?

If this doesn't help, I would recommend you to submit a support ticket regarding the same as Smartsheet connector is still under preview .

Know more about smartsheet connector here: Transform data in Smartsheet (Preview) using Azure Data Factory or Synapse Analytics

Hope it helps. Kindly let us know if it's helpful. Thankyou
TyroneM 5 Reputation points

2023-05-25T09:32:00.22+00:00

Hi AnnuKumari-MSFT

Thanks for the response, no problems with blank rows but if you notice the datatype of [Target] column in the ADF preview is already text, the column has both text and numeric data, but the sourcing is converting the numeric percentage data to what seems to be an int datatype eg. 30% in source becomes 0.3 in target
AnnuKumari-MSFT 33,721 Reputation points Microsoft Employee

2023-06-07T09:54:17.33+00:00

Hi TyroneM ,

Thanks for insights. However, it is difficult to reproduce your case due to lack of smartsheet environment. I would recommend you to unblock yourself by creating the support requested as mentioned above. Please do share the resolution here with the community if it gets fix. Thankyou

Share via

ADF Smartsheets connector incorrectly converts data when sourcing

Your answer