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}]