This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We have a requirement to filter the API response and load the filter data into different cosmos containers. used webActivity, Filter Activity and CopyActivity. as below. ![232277-image.png][1] Copy Activity source configured as below. ![232317-image.png][2] The out come of filter activity is below. need to load all objects inside the value array { "source": { "type": "CosmosDbSqlApiSource", "additionalColumns": [ { "name": "JsonOutput", "value": [ { "ApplicationAdmitYear": 2021, "Country": "US", "ApplicationDate": "2021-05-12T00:00:00Z ", "ApplicationNumber": 12345, "ApplicationProgressStatus": [ { "ActionDate": { "DateTime": "2021-05-13T00:00:00Z " } } ] }, { "ApplicationAdmitYear": 2021, "Country": "AUS", "ApplicationDate": "2021-05-12T00:00:00Z ", "ApplicationNumber": 12345, "ApplicationProgressStatus": [ { "ActionDate": { "DateTime": "2021-05-13T00:00:00Z " } } ] } ] } ] } } Getting below error in Copy activity , any suggestions and help please Details ErrorCode=UserErrorInvalidValueInPayload,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to convert the value in 'value' property to 'System.String' type. Please make sure the payload structure and value are correct.,Source=Microsoft.DataTransfer.DataContracts,''Type=System.InvalidCastException,Message=Object must implement IConvertible.,Source=mscorlib,' [1]: /api/attachments/232277-image.png?platform=QnA [2]: /api/attachments/232317-image.png?platform=QnA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 3%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV0%3C/text%3E%3C/svg%3E)
Hi anonymous user,
If you want to store data into cosmos then it should be your sink. And also I believe the response you have shared is the output of web activity.
Thanks @VinodKumar-0434 looking into it. Below the source API response { "metadata": [ { "count": 1000, "page_num": 1, "page_count": 6, "total_count": 5225 } ], "data": [ { "ApplicationAdmitYear": 2021, "Country": "US", "ApplicationDate": "2021-05-12T00:00:00Z ", "ApplicationNumber": 12345, "ApplicationProgressStatus": [ { "ActionDate": { "DateTime": "2021-05-13T00:00:00Z " } } ] }, { "ApplicationAdmitYear": 2021, "Country": "UF", "ApplicationDate": "2021-05-12T00:00:00Z ", "ApplicationNumber": 4567, "ApplicationProgressStatus": [ { "ActionDate": { "DateTime": "2021-05-13T00:00:00Z " } } ] } ]} and this one is filter activity output { "ItemsCount": 1000, "FilteredItemsCount": 247, "Value": [ { "ApplicationAdmitYear": 2021, "Country": "US", "ApplicationDate": "2021-05-12T00:00:00Z ", "ApplicationNumber": 12345, "ApplicationProgressStatus": [ { "ActionDate": { "DateTime": "2021-05-13T00:00:00Z " } } ] }]} what i was trying to do is , the "Value" array of the filter activity output trying to load in cosmos. For that i used copy activity. In copy activity source , i didnt find the option to use filter activity output hence taken dummy source (not return any data) with additional column and the logic is @activity('Filter US Data').output.value . ![232486-image.png][1] ![232460-image.png][2] [1]: /api/attachments/232486-image.png?platform=QnA [2]: /api/attachments/232460-image.png?platform=QnA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Thanks, @VinodKumar-0434
Hi anonymous user,
Welcome to the MS Q&A platform.
Were you able to find out the issue, or please let us know if you need any further help here?
The issue is not fixed . Struggling to pass the filter activity output value to copy activity as a input.
Any suggestions?
Hi anonymous user,
As per the error message, It seems like the data conversion issue. Could you please try changing the data type at the cosmos end and re-import the schema and mapping in the copy activity?
Hi anonymous user,
I am just checking in to see if you have any updates here.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 8%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hi , I have a question regarding copy activity and filter activity for transfer file from source to ADFS. is this activity works together or I have to use getMetadata activity instead copy activity?