How can I use for each item in Microsoft Fabric data mapping

Question

Hi,

I have copy data action inside for each loop action. Copy data action fetches data from REST API and as it is stored into data lake, I would like to append the ID of the iterated item into data lake row. I tried to do this with following syntax, but it does not work. It produces an error

"ErrorCode=UserErrorSchemaMappingCannotInferSinkColumnType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Data type of column 'courseid' can't be inferred from 1st row of data, please specify its data type in mappings of copy activity or structure of DataSet.,Source=Microsoft.DataTransfer.Common"

Answer 1

@Anonymous Welcome to Microsoft Q&A forum and thanks for reaching out here.

Looks like your ask is related to Microsoft Fabric Data facrory and not Azure Data factory. If that is the case, I recommend reaching out in Microsoft Fabrick community forum: https://community.fabric.microsoft.com/t5/Data-Factory-preview-Community/ct-p/datafactory

If your ask is not related to Fabric, please let me know.

Hope this helps.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.