Import Zip file to D365 F&O with webactivity

Question

Hi Team,

I am trying upload .zip file to D365 F&O with ADF, but while importing it is failed with below error

When i tried to upload file content to F&O it is getting success but import is failed. below is the screen for put activity

and body which is passed from 'get zip file content' activity response.
for import activity screen is below

could you please help me to upload and import file to D365 F&O.

and one more thing which i observed if i pass "Content-Type": "application/octet-stream" in put activity header it is zipping and uploading my file but export is fail with below error

If i receive quick response it would be great.

Answer 1

Hello Team,

Even if work with single zip file also same issue in webactivity, below is the scenario which i have tried for the csv file.

this is my zipped csv file from source container.

here is the pipeline running with zip file and putting it inti destination.
after put into in destination container dev

once i have downloaded and unzipped i am getting below error

I am trying to do just lift and shift from one container to another but after putting same zip file is not able to unzip and getting error with invalid zip.

web 1 input :
{
"url": "https://pvlab036a32adls.blob.core.windows.net/test/Vendors V2.zip",
"method": "GET",
"headers": {
"x-ms-blob-type": "BlockBlob",
"x-ms-version": "2017-11-09"
},
"authentication": {
"type": "MSI",
"resource": "https://storage.azure.com/"
}
}

Output :

{
"Response": "PK\u0003\u0004\u0014\u0000\u0000\u0000\b\u0000\"��T>Vl\u0001�\u0000\u0000\u0000�\u0001\u0000\u0000\u000e\u0000\u0000\u0000Vendors V2.csvm�1n�0\fE�\u0000��\u000f��iO�P�C��\f�2�nY�zI�\"K{��v� @7���)|��!\u001a\u0012Ŭ��߳\u0001�`�\u0012���y^[1n%��\u0007��9p\"����&%G�#�1;�s\u0012��۞�)\u0006\u0006���Z耢�}\u0015��x'��u6t�\u0016(��RYb�c\u0014��\"\u001dj����\u001f�R�W����;��I�V�CT��׃��<��J�Q�\r�Kn�\u00074/\u000f�E�2�v\u0003t\u0010��\u0013\u0002\u0000!�^��v\r�ֆ]�#C��ܡ�uu\u0005\u0000�yD�\u001d�t�n�{C���\f\u0010�>����x�Χ��\u0017PK\u0001\u0002\u0014\u0000\u0014\u0000\u0000\u0000\b\u0000\"��T>Vl\u0001�\u0000\u0000\u0000�\u0001\u0000\u0000\u000e\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001\u0000 \u0000\u0000\u0000\u0000\u0000\u0000\u0000Vendors V2.csvPK\u0005\u0006\u0000\u0000\u0000\u0000\u0001\u0000\u0001\u0000<\u0000\u0000\u0000+\u0001\u0000\u0000\u0000\u0000",
"ADFWebActivityResponseHeaders": {
"x-ms-request-id": "f852512b-e01e-006e-724c-4a9f9e000000",
"x-ms-version": "2017-11-09",
"x-ms-creation-time": "Thu, 07 Apr 2022 06:58:41 GMT",
"x-ms-lease-status": "unlocked",
"x-ms-lease-state": "available",
"x-ms-blob-type": "BlockBlob",
"x-ms-server-encrypted": "true",
"Accept-Ranges": "bytes",
"Date": "Thu, 07 Apr 2022 06:59:11 GMT",
"ETag": "\"0x8DA18640CF01814\"",
"Server": "Windows-Azure-Blob/1.0;Microsoft-HTTPAPI/2.0",
"Content-Length": "381",
"Content-MD5": "3LkeSw8QthludlQxcKOKjA==",
"Content-Type": "application/x-zip-compressed",
"Last-Modified": "Thu, 07 Apr 2022 06:58:41 GMT"
},
"effectiveIntegrationRuntime": "AutoResolveIntegrationRuntime (Canada Central)",
"executionDuration": 0,
"durationInQueue": {
"integrationRuntimeQueue": 0
},
"billingReference": {
"activityType": "ExternalActivity",
"billableDuration": [
{
"meterType": "AzureIR",
"duration": 0.016666666666666666,
"unit": "Hours"
}
]
}
}

Web 2 Input :
{
"url": "https://pvlab036a32adls.blob.core.windows.net/dev/Vendors V2.zip",
"method": "PUT",
"headers": {
"x-ms-blob-type": "BlockBlob",
"x-ms-version": "2017-11-09"
},
"body": "PK\u0003\u0004\u0014\u0000\u0000\u0000\b\u0000\"��T>Vl\u0001�\u0000\u0000\u0000�\u0001\u0000\u0000\u000e\u0000\u0000\u0000Vendors V2.csvm�1n�0\fE�\u0000��\u000f��iO�P�C��\f�2�nY�zI�\"K{��v� @7���)|��!\u001a\u0012Ŭ��߳\u0001�`�\u0012���y^[1n%��\u0007��9p\"����&%G�#�1;�s\u0012��۞�)\u0006\u0006���Z耢�}\u0015��x'��u6t�\u0016(��RYb�c\u0014��\"\u001dj����\u001f�R�W����;��I�V�CT��׃��<��J�Q�\r�Kn�\u00074/\u000f�E�2�v\u0003t\u0010��\u0013\u0002\u0000!�^��v\r�ֆ]�#C��ܡ�uu\u0005\u0000�yD�\u001d�t�n�{C���\f\u0010�>����x�Χ��\u0017PK\u0001\u0002\u0014\u0000\u0014\u0000\u0000\u0000\b\u0000\"��T>Vl\u0001�\u0000\u0000\u0000�\u0001\u0000\u0000\u000e\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001\u0000 \u0000\u0000\u0000\u0000\u0000\u0000\u0000Vendors V2.csvPK\u0005\u0006\u0000\u0000\u0000\u0000\u0001\u0000\u0001\u0000<\u0000\u0000\u0000+\u0001\u0000\u0000\u0000\u0000",
"authentication": {
"type": "MSI",
"resource": "https://storage.azure.com/"
}
}

Output :
{
"Response": "",
"ADFWebActivityResponseHeaders": {
"x-ms-request-id": "c5a36184-401e-0015-0a4c-4add02000000",
"x-ms-version": "2017-11-09",
"x-ms-request-server-encrypted": "true",
"Date": "Thu, 07 Apr 2022 06:59:14 GMT",
"ETag": "\"0x8DA186420B672A1\"",
"Server": "Windows-Azure-Blob/1.0;Microsoft-HTTPAPI/2.0",
"Content-Length": "0",
"Content-MD5": "sUmAfiHzP7V3KQXXihAUkQ==",
"Last-Modified": "Thu, 07 Apr 2022 06:59:15 GMT"
},
"effectiveIntegrationRuntime": "AutoResolveIntegrationRuntime (Canada Central)",
"executionDuration": 0,
"durationInQueue": {
"integrationRuntimeQueue": 0
},
"billingReference": {
"activityType": "ExternalActivity",
"billableDuration": [
{
"meterType": "AzureIR",
"duration": 0.016666666666666666,
"unit": "Hours"
}
]
}
}

Could you please help us which we passing the body and headers are good or do we need to add some thing for it to put proper zip file to the destination.

If required we can have screen share session with MS team, and i guess this is issue with web activity product, we can try to avoid creating mess up with customers ASAP.

Thanks in advance.

Answer 2

Hello @KranthiPakala-MSFT

I have raised support case #2204090030000330 but i am not receiving proper response from the support team. Still they are in initial stage, we need to find this bug how can we resolved ASAP.

Regards,
Mahesh

Answer 3

This is product limit, and not possible with ADF we can use logic app to achieve this flow.

Regards,
Mahesh

Answer 4

Hi @KranthiPakala-MSFT Is this issue is resolved in with web activity ?