Skip to main content
Question

Can FMS call its own APIs through a scheduled process?

  • March 14, 2023
  • 3 replies
  • 52 views

Forum|alt.badge.img+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

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • March 14, 2023

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!


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • March 15, 2023

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.


Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • March 15, 2023

@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!