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

[MichaelTH]

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.

[Anonymous]

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]

Hi @MichaelTH ,

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

[Anonymous]

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 .

[Anonymous]

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 .