Forum Discussion

MichaelTH's avatar
MichaelTH
Frequent Visitor
2 years ago

How to fix mapping error involving null value from rest api source

I am using a rest api to copy data into a data warehouse through data pipeline. There is a column from source containing null value. When mapping, the source column sets as string type to destination column string type.

 

When I try to run the pipeline, the copy data activity throws error: "UserErrorSchemaMappingCannotInferdestinationColumnType: ErrorCode=UserErrorSchemaMappingCannotInferdestinationColumnType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Data type of column 'property_street2' can't be inferred from 1st row of data, please specify its data type in mappings of copy activity or structure of data.,Source=Microsoft.DataTransfer.Common,"

 

How should this error to be fixed?

 

Thanks.

General Question
Need Help
pipelines

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MichaelTH ,

    We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi MichaelTH ,

      Can you please try to explicitly define schema mapping?
      Let me know if you are still facing the issue.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hello MichaelTH ,
        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help .