Not able to pass DataTable into Orchestrator Queue

Hello -

I am having issues using the ‘Bulk Add Queue Items’ activity.

I am trying to upload data returned from an API to a queue in the Orchestrator. I have tried defining the Specific Data JSON Schema in the queue. I tried writing the data to a datatable and then uploading the datatable but, an array of objects (‘custom_steps_seperated’) is missing from the ‘custom_storyboard’ key.

The raw data is at the end of this post

There are two records in the JSON string. My goal is to upload these two records to an Orchestrator queue and maintain all of the data.

When I parse the JSON string using an online parser I, I get the following results:



Has anyone had this issue? Thank you in advance for any insight or guidance on this!

Regards,
symilawr

Raw data is below:

[{"id":18548,"case_id":7870,"status_id":1,"assignedto_id":null,"run_id":316,"title":"Bank File Validity - TT-1-Test Bank 1-US-Money Transfer - UU-TT-B1-US-BKTR","template_id":5,"type_id":3,"priority_id":4,"estimate":null,"estimate_forecast":null,"refs":"P001","milestone_id":null,"custom_active":true,"custom_automation_type":0,"custom_polarization":100,"custom_execution":200,"custom_owner":null,"custom_application":200,"custom_module":null,"custom_functional_area":null,"custom_quality_review_status":null,"custom_user_guide":null,"custom_approach":1,"custom_test_package":"Test Package 1","custom_automation":"Bank File Validity","custom_reason_inactive":null,"custom_preconds":null,"custom_steps":null,"custom_expected":null,"custom_storyboard":"Purpose : This test case is intended to validate the Bank Web App functionality to send a manual Accounting payment in the scenario detailed below.\r\n\r\nBank: Test Bank 1\r\nCountry: US\r\nPayment type: Money Transfer\r\nTemplate: UU-TT-B1-US-BKTR\r\n\r\nSuccess criteria: The payment is received and acknowledged by the bank.\r\n","custom_steps_separated":[{"content":"Instructions: Log on to Bank Web App and navigate to 'Manual Transactions' module","expected":"Expected Result: Logged in to Bank Web App","additional_info":"","refs":""},{"content":"Instructions: Under 'Manual Transactions' tab select Accounting\/Accounting Payments\/Payment. Right-click on main grid screen and select Accounting - Partial Permission Template. Select the template 'Accounting - Partial Permission Template' and populate the required fields. Finally save the payment.","expected":"Expected Result: Payment Created","additional_info":"","refs":""},{"content":"Instructions: Once the payment is created in the main grid screen, select the Payment, Right click and select 'Accept in Pay'. The payment now moves into Payment Facility module\/workflow for approval.","expected":"Expected Result: Payment removed from 'Manual Payment' screen and added to 'Payment Facility'","additional_info":"","refs":""},{"content":"Instructions: Monitor the payment status in Bank Web App Payment Facility to verify that the payment has been released to the bank.","expected":"Expected Result: Payment has been processed by Bank Web App and released to the bank","additional_info":"","refs":""},{"content":"Monitor the payment status in Bank Web App Payment Facility - Status feedback","expected":"Expected Result: Monitor to ensure Acknowledgment is received in Bank Web App","additional_info":"","refs":""}],"custom_mission":null,"custom_goals":null,"sections_display_order":1,"cases_display_order":1},{"id":18549,"case_id":7871,"status_id":1,"assignedto_id":null,"run_id":316,"title":"Bank File Validity - TT-1-Test Bank 1-US-Domestic Urgent \/ Wire - UU-TT-B1-US-DOM WIRE","template_id":5,"type_id":3,"priority_id":4,"estimate":null,"estimate_forecast":null,"refs":"P002","milestone_id":null,"custom_active":true,"custom_automation_type":0,"custom_polarization":100,"custom_execution":200,"custom_owner":null,"custom_application":200,"custom_module":null,"custom_functional_area":null,"custom_quality_review_status":null,"custom_user_guide":null,"custom_approach":1,"custom_test_package":"Test Package 1","custom_automation":"Bank File Validity","custom_reason_inactive":null,"custom_preconds":null,"custom_steps":null,"custom_expected":null,"custom_storyboard":"Purpose : This test case is intended to validate the Bank Web App functionality to send a manual Accounting payment in the scenario detailed below.\r\n\r\nBank: Test Bank 1\r\nCountry: US\r\nPayment type: Domestic Urgent \/ Wire\r\nTemplate: UU-TT-B1-US-DOM WIRE\r\n\r\nSuccess criteria: The payment is received and acknowledged by the bank.\r\n","custom_steps_separated":[{"content":"Instructions: Log on to Bank Web App and navigate to 'Manual Transactions' module","expected":"Expected Result: Logged in to Bank Web App","additional_info":"","refs":""},{"content":"Instructions: Under 'Manual Transactions' tab select Accounting\/Accounting Payments\/Payment. Right-click on main grid screen and select Accounting - Partial Permission Template. Select the template 'Accounting - Partial Permission Template' and populate the required fields. Finally save the payment.","expected":"Expected Result: Payment Created","additional_info":"","refs":""},{"content":"Instructions: Once the payment is created in the main grid screen, select the Payment, Right click and select 'Accept in Pay'. The payment now moves into Payment Facility module\/workflow for approval.","expected":"Expected Result: Payment removed from 'Manual Payment' screen and added to 'Payment Facility'","additional_info":"","refs":""},{"content":"Instructions: Monitor the payment status in Bank Web App Payment Facility to verify that the payment has been released to the bank.","expected":"Expected Result: Payment has been processed by Bank Web App and released to the bank","additional_info":"","refs":""},{"content":"Monitor the payment status in Bank Web App Payment Facility - Status feedback","expected":"Expected Result: Monitor to ensure Acknowledgment is received in Bank Web App","additional_info":"","refs":""}],"custom_mission":null,"custom_goals":null,"sections_display_order":1,"cases_display_order":2}]

Are you trying to add queue item as individual keys or you trying to add it in a single key. If you want to add individual keys, you have to add them with key/value pair in item information.

If you want to add it as a single key, serialize your data table and add the key as an object since your json result has huge content.

Newtonsoft.Json.JsonConvert.SerializeObject(**Datatable** )