Question

Can FMS call its own APIs through a scheduled process?

  • 14 March 2023
  • 3 replies
  • 49 views

Badge +2

Can FMS call its own APIs through a scheduled process?

We are currently using FSM 6.22 with a on prem solution.  We have a custom purchase order table in the FSM database and want to use FSM’s purchase order APIs to create the PO through the app by using a scheduled process of the data in the custom table.


3 replies

Userlevel 6
Badge +26

Hey @gdfmdamveld 

You should use the XML method to create records.

Depends on you logic, this is an example

<update_purchase_order>
<purchase_order>
<purchase_order_id>PO_ID</purchase_order_id>
<address_id>ADD_ID</address_id>
<cost_status>COST_STAT</cost_status>
<allow_partials>ALLOW_PARTIALS</allow_partials>
<needs_order_ack>NEEDS</needs_order_ack>
<needs_ship_ack>NEEDS</needs_ship_ack>
<place_id_ship_to>SHIP_TO</place_id_ship_to>
<po_status>STATUS</po_status>
<ship_via>VIA</ship_via>
<supplier_id>SUPP</supplier_id>
<times_printed>TIMES</times_printed>
<wanted_receipt_dt>REC_DT</wanted_receipt_dt>
<insert is_initialized="False" />
</purchase_order>
</update_purchase_order>

Cheers!

Badge +2

Thank you Shneor, the XML with a business rule was our other option but was fearful of performance issues.  We will put our effort into the business rule leveraging XML.  Have a blessed day.

Userlevel 6
Badge +26

@gdfmdamveld 

Please say what performance issue you encounter, the community might help.

Anyhow, you can either use business rules or use the XML directly in your process, depends on what exactly you need.

Cheers!

Reply