Precisely Enterworks

 View Only
  • 1.  Possibility of making Enable API Call from EPX worklfow BIC

    Posted 08-30-2024 12:11

    I am exploring a possibility to make Codeset value update or delete from EPX workflow.

    • How can I edit a codeset value from EPX BICs?
    • Any way I can make a Enable API call to make this codeset value update?

    Thanks
    Bighnajit



    ------------------------------
    Bighnajit Mishra
    Lululemon Athletica
    ------------------------------


  • 2.  RE: Possibility of making Enable API Call from EPX worklfow BIC

    Employee
    Posted 08-30-2024 16:36

    Bighnajit,

    There is no native support for updating code sets from an EPX workflow.  Nor is there native support for invoking any EnterWorks REST API call from EPX workflow.  For the latter, it would be necessary to implement a Callout BIC that connects to EnterWorks via the REST API and makes the appropriate calls. 

    An alternative would be to define a SQL Stored procedure that can be invoked by the SQL Set Properties activity.  This stored procedure would perform the necessary SQL updates to the Code set table.  However, doing so is not part of the official Public API for EnterWorks so such a solution would be at-risk with each new release, even though the likelihood of the internal schema for Code Sets changing may be quite low.  There are some ongoing discussions with Product Management regarding using SQL Stored Procedures in this manner.  I should have an update to this specific question sometime next week (Monday is a holiday and I will be out on Tuesday).



    ------------------------------
    Brian Zupke
    Precisely Software Inc.
    ------------------------------