Upload missing document relationship in Process Plan. "Add" statement doesn't work
I need to upload relationship between Operation Document and the Documents.
As you can see from the picture below the hierarchy of Process Plan is:
Process Plan--> Operation Number (which is `sort_order`, in this case it is 20)-->Document
I have an excel sheet of the missing documents that need to show under an operation (20)
The document relationship cannot by uploaded just to Operation because the operation 20 will exist under other Process Plans.
However, under one process plan the operation number is unique, so in this case there will be only one operation with sort_order 20.
The documents already exist, I just need them to be shown here.
From the AML script I have the `get` command works. The code is below.
<AML>
<Item type="mpp_processPlan" action="get">
<item_number>080824-S10</item_number>
<Relationships>
<Item type="mpp_Operation" action="get">
<sort_order>20</sort_order>
<Relationships>
<Item type="mpp_operationDocument" action="get">
</Item>
</Relationships>
</Item>
</Relationships>
</Item>
</AML>
However, in the above script in the line `<Item type="mpp_operationDocument" action="get">` when `action = Update` it won't work.
Basically the following doesn't work
<AML>
<Item type="mpp_processPlan" action="get">
<item_number>080824-S10</item_number>
<Relationships>
<Item type="mpp_Operation" action="get">
<sort_order>20</sort_order>
<Relationships>
<Item type="mpp_operationDocument" action="Update">
<item_number>MADL074161</item_number>
</Item>
</Relationships>
</Item>
</Relationships>
</Item>
</AML>
Result of scriopt with all `action=get`
[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:b4eb42d4-78c3-44de-b633-1a7d250b7129:type=text&text=%3CSOAP-ENV%3AEnvelope%20xmlns%3ASOAP-ENV%3D%22http%3A%2F%2Fschemas.xmlsoap.org%2Fsoap%2Fenvelope%2F%22%3E%0A%3CSOAP-ENV%3ABody%3E%0A%3CResult%3E%0A%3CItem%20type%3D%22mpp_ProcessPlan%22%20typeId%3D%224E030A4723224002B3E94F40F01AC1DE%22%20id%3D%22767F3FCDCC0F4CCF95F3CA3D9DB9D391%22%3E%0A%3Cconfig_id%20keyed_name%3D%22080824-S10%22%20type%3D%22mpp_ProcessPlan%22%3E767F3FCDCC0F4CCF95F3CA3D9DB9D391%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22Data%20Migration%22%20type%3D%22User%22%3E08880028FF8C43D48CB02B44EB74B127%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-20T11%3A49%3A02%3C%2Fcreated_on%3E%0A%3Ccurrent_state%20name%3D%22Released%22%20keyed_name%3D%22Released%22%20type%3D%22Life%20Cycle%20State%22%3E7109CDD337C84AFF87F55B21CCAC34AC%3C%2Fcurrent_state%3E%0A%3Cdescription%3E%3C%2Fdescription%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Chas_change_pending%3E0%3C%2Fhas_change_pending%3E%0A%3Cid%20keyed_name%3D%22080824-S10%22%20type%3D%22mpp_ProcessPlan%22%3E767F3FCDCC0F4CCF95F3CA3D9DB9D391%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E1%3C%2Fis_released%3E%0A%3Ckeyed_name%3E080824-S10%3C%2Fkeyed_name%3E%0A%3Clocation%3E10%3C%2Flocation%3E%0A%3Cmajor_rev%3EPP000%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2024-02-20T11%3A49%3A02%3C%2Fmodified_on%3E%0A%3Cname%3ESlitter%20Knife%20Arm%2C%20Rotary%20Tip%2C%2035%22%20Ring%2C%20C%2FR%3C%2Fname%3E%0A%3Cnew_version%3E1%3C%2Fnew_version%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cowned_by_id%20keyed_name%3D%22Mfg%20Eng%22%20type%3D%22Identity%22%3ED46B8ECBDB0C4D94BFF7A93D36FAB474%3C%2Fowned_by_id%3E%0A%3Cpermission_id%20keyed_name%3D%22Process%20Plan%20-%20Released%22%20type%3D%22Permission%22%3EE4EB045B2622409BA09AC91778FAE18C%3C%2Fpermission_id%3E%0A%3Crelease_date%3E2024-01-29T00%3A00%3A00%3C%2Frelease_date%3E%0A%3Cstate%3EReleased%3C%2Fstate%3E%0A%3Citem_number%3E080824-S10%3C%2Fitem_number%3E%0A%3Citemtype%3E4E030A4723224002B3E94F40F01AC1DE%3C%2Fitemtype%3E%0A%3CRelationships%3E%0A%3CItem%20type%3D%22mpp_Operation%22%20typeId%3D%2291B674D7C7AF47F99CA1C2FB26C38DBF%22%20id%3D%2277DD37200C7B4858833A6D6D8A48F4FA%22%3E%0A%3Cconfig_id%20keyed_name%3D%2220%22%20type%3D%22mpp_Operation%22%3E77DD37200C7B4858833A6D6D8A48F4FA%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22Data%20Migration%22%20type%3D%22User%22%3E08880028FF8C43D48CB02B44EB74B127%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-20T12%3A06%3A27%3C%2Fcreated_on%3E%0A%3Ccycle_time%3E60%3C%2Fcycle_time%3E%0A%3Cdescription%20xml%3Alang%3D%22en%22%3EMC-1B%20MC2%20CNC%20Machine%20Centre%20S10%3C%2Fdescription%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Cid%20keyed_name%3D%2220%22%20type%3D%22mpp_Operation%22%3E77DD37200C7B4858833A6D6D8A48F4FA%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E0%3C%2Fis_released%3E%0A%3Ckeyed_name%3E20%3C%2Fkeyed_name%3E%0A%3Cmajor_rev%3EPP000%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2024-02-20T12%3A06%3A27%3C%2Fmodified_on%3E%0A%3Cname%20xml%3Alang%3D%22en%22%3EMC-1B%3C%2Fname%3E%0A%3Cnew_version%3E1%3C%2Fnew_version%3E%0A%3Cnmg_erp_name%3EMC-1B%3C%2Fnmg_erp_name%3E%0A%3Cnmg_location_id%3E10%3C%2Fnmg_location_id%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cpermission_id%20keyed_name%3D%22Process%20Plan%20-%20Released%22%20type%3D%22Permission%22%3EE4EB045B2622409BA09AC91778FAE18C%3C%2Fpermission_id%3E%0A%3Csetup_time%3E0%3C%2Fsetup_time%3E%0A%3Csource_id%20keyed_name%3D%22080824-S10%22%20type%3D%22mpp_ProcessPlan%22%3E767F3FCDCC0F4CCF95F3CA3D9DB9D391%3C%2Fsource_id%3E%0A%3Cwi_details%20xml%3Alang%3D%22en%22%3E%3C%2Fwi_details%3E%0A%3Csort_order%3E20%3C%2Fsort_order%3E%0A%3CRelationships%3E%0A%3CItem%20type%3D%22mpp_OperationDocument%22%20typeId%3D%2238BA57E0616B49A58317C267E436AE4C%22%20id%3D%22106F5032EE7F4C5497717888370A3BB6%22%3E%0A%3Cconfig_id%20keyed_name%3D%22106F5032EE7F4C5497717888370A3BB6%22%20type%3D%22mpp_OperationDocument%22%3E106F5032EE7F4C5497717888370A3BB6%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22Data%20Migration%22%20type%3D%22User%22%3E08880028FF8C43D48CB02B44EB74B127%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-20T12%3A36%3A02%3C%2Fcreated_on%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Cid%20keyed_name%3D%22106F5032EE7F4C5497717888370A3BB6%22%20type%3D%22mpp_OperationDocument%22%3E106F5032EE7F4C5497717888370A3BB6%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E0%3C%2Fis_released%3E%0A%3Ckeyed_name%3E106F5032EE7F4C5497717888370A3BB6%3C%2Fkeyed_name%3E%0A%3Cmajor_rev%3EA%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2024-02-20T12%3A36%3A02%3C%2Fmodified_on%3E%0A%3Cnew_version%3E1%3C%2Fnew_version%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cpermission_id%20keyed_name%3D%22Process%20Plan%20-%20Released%22%20type%3D%22Permission%22%3EE4EB045B2622409BA09AC91778FAE18C%3C%2Fpermission_id%3E%0A%3Crelated_id%20keyed_name%3D%22MADL074152%22%20type%3D%22Document%22%3E%0A%3CItem%20type%3D%22Document%22%20typeId%3D%22B88C14B99EF449828C5D926E39EE8B89%22%20id%3D%22BD9ECB6D5C5D4AEEBC0ED65680C5505C%22%3E%0A%3Cclassification%3EManufacturing%20Aid%3C%2Fclassification%3E%0A%3Cconfig_id%20keyed_name%3D%22MADL074152%22%20type%3D%22Document%22%3EBD9ECB6D5C5D4AEEBC0ED65680C5505C%3C%2Fconfig_id%3E%0A%3Ccreated_by_id%20keyed_name%3D%22NMIS%20_MADL%22%20type%3D%22User%22%3E41E9090B65234C899CAFF690C7C0F562%3C%2Fcreated_by_id%3E%0A%3Ccreated_on%3E2024-02-19T11%3A12%3A07%3C%2Fcreated_on%3E%0A%3Ccurrent_state%20name%3D%22Released%22%20keyed_name%3D%22Released%22%20type%3D%22Life%20Cycle%20State%22%3E8EDE39438A7E4A56A1B4A9D07EF4A2FF%3C%2Fcurrent_state%3E%0A%3Cdescription%3E35%22%20SLITTER%20ARM%20C%2FR%3C%2Fdescription%3E%0A%3Ceffective_date%3E2018-11-16T14%3A35%3A00%3C%2Feffective_date%3E%0A%3Cgeneration%3E1%3C%2Fgeneration%3E%0A%3Chas_change_pending%3E0%3C%2Fhas_change_pending%3E%0A%3Chas_files%3E1%3C%2Fhas_files%3E%0A%3Cid%20keyed_name%3D%22MADL074152%22%20type%3D%22Document%22%3EBD9ECB6D5C5D4AEEBC0ED65680C5505C%3C%2Fid%3E%0A%3Cis_current%3E1%3C%2Fis_current%3E%0A%3Cis_released%3E1%3C%2Fis_released%3E%0A%3Cis_template%3E0%3C%2Fis_template%3E%0A%3Ckeyed_name%3EMADL074152%3C%2Fkeyed_name%3E%0A%3Cmajor_rev%3EV007%3C%2Fmajor_rev%3E%0A%3Cmodified_on%3E2007-07-09T08%3A17%3A00%3C%2Fmodified_on%3E%0A%3Cname%3E080824%3C%2Fname%3E%0A%3Cnew_version%3E0%3C%2Fnew_version%3E%0A%3Cnmg_department%3EManufacturing%3C%2Fnmg_department%3E%0A%3Cnmg_type%3EProgram%20%28CAD%2FCAM%29%3C%2Fnmg_type%3E%0A%3Cnot_lockable%3E0%3C%2Fnot_lockable%3E%0A%3Cowned_by_id%20keyed_name%3D%22Mfg%20Eng%22%20type%3D%22Identity%22%3ED46B8ECBDB0C4D94BFF7A93D36FAB474%3C%2Fowned_by_id%3E%0A%3Cpermission_id%20keyed_name%3D%22Released%20Document%22%20type%3D%22Permission%22%3E74C205C37E7C4D56BBBE99B52B28431E%3C%2Fpermission_id%3E%0A%3Crelease_date%3E2018-11-16T14%3A35%3A00%3C%2Frelease_date%3E%0A%3Cstate%3EReleased%3C%2Fstate%3E%0A%3Citem_number%3EMADL074152%3C%2Fitem_number%3E%0A%3Citemtype%3EB88C14B99EF449828C5D926E39EE8B89%3C%2Fitemtype%3E%0A%3C%2FItem%3E%0A%3C%2Frelated_id%3E%0A%3Csource_id%20keyed_name%3D%2220%22%20type%3D%22mpp_Operation%22%3E77DD37200C7B4858833A6D6D8A48F4FA%3C%2Fsource_id%3E%0A%3C%2FItem%3E%0A%3C%2FRelationships%3E%0A%3C%2FItem%3E%0A%3C%2FRelationships%3E%0A%3C%2FItem%3E%0A%3C%2FResult%3E%0A%3C%2FSOAP-ENV%3ABody%3E%0A%3C%2FSOAP-ENV%3AEnvelope%3E]