Watson Supply Chain Ideas

Submit new product ideas for Watson Supply Chain solutions. Before you submit, please review existing ideas; if an idea close to yours already exists, it's better to add comments or vote on the existing idea. We will review your ideas and use them to help prioritize our product development. Best of all, the portal will automatically update you when the status of your idea has been changed. Order Management, Store Engagement, Watson Order Optimizer, Inventory Visibility, CPQ and Call Center are now part of Watson Supply Chain

Connect with IBM experts and your peers on the Supply Chain Collaboration Community and the Order Management Interest Group

Submit ideas for other Watson Customer Engagement Products:

Watson Marketing
Watson Campaign Automation
Watson Commerce

REST API to delete webservice in ISBI

We are currently using ISBI REST APIs for automated partner on-boarding.
REST API to Create WebService --> There is no REST API to create a WebService in ISBI.
REST API to Delete WebService --> There is no REST API to delete an existing WebService in ISBI.

So we need ISBI Rest APIs to enable us to create and delete WebService automatically without below work-arounds.

Automated Workaround to Create WebService --> We are using import export functionlaity to get WebService created automatically.
Automated Workaround to Create WebService --> We have figured out below sql statements which we can put in a stored procedure and call it from business process to delete a webservice automatically.
 delete from WS_IN_SECURITY where WS_CONFIG_NAME='<name of web service>'
 delete from WS_OUT_SECURITY where WS_CONFIG_NAME='<name of web service>'
 delete from WEB_SERVICE_CONFIG where object_id in (select object_id from WEB_SERVICE_DEF where name='<name of web service>')
 delete from WEB_SERVICE_DEF where name='<name of web service>'
 delete from WEB_SERVICE_ID where next_ws_id in (select object_id from WEB_SERVICE_DEF where name='<name of web service>')
 delete from WEB_SERVICE_SETTINGS where web_service_name='<name of web service>'
 update YFS_RESOURCE SET STATUS = 0  WHERE RESOURCE_KEY in  ( select RESOURCE_KEY from YFS_RESOURCE where RESOURCE_ID = '<name of web service>ws' )
 delete from YFS_RESOURCE_PERMISSION where RESOURCE_KEY in  ( select RESOURCE_KEY from YFS_RESOURCE where RESOURCE_ID = '<name of web service>.ws' )
 Note: As long as we have not assigned a consumer to the web service (feature is no longer recommended as per IBM) the last delete is not needed.
 

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Feb 15 2018
  • Needs review
How will this idea be used?

We need ISBI Rest APIs to enable us to create and delete WebService automatically.

What is your industry? Banking
What is the idea priority? Urgent
DeveloperWorks ID
RTC ID
Link to original RFE
  • Attach files