Bug fixing in topology discovery as part of CCVPN (Cross-Layer Cross-Domain VPN)...
[sdnc/oam.git] / platform-logic / datachange / src / main / xml / DataChange_esr-thirdparty-sdnc-discovery.xml
index 0d47536..007f3bf 100644 (file)
-<service-logic
-    xmlns='http://www.onap.org/sdnc/svclogic'
-    xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='DataChange' version='${project.version}'>
-    <method rpc='esr-thirdparty-sdnc-discovery' mode='sync'>
-        <block atomic="true">
-            <switch test="`$data-change-notification-input.aai-event-trigger`">
-                <outcome value='Update'>
-                    <block>
-                        <switch test="`$prop.sdncRestApi.type`">
-                            <outcome value='SOTN'>
-                                <block atomic="true">
-                                    <execute plugin='org.onap.ccsdk.sli.plugins.prop.PropertiesNode' method='readProperties' >
-                                        <parameter name='fileName' value='%SDNC_CONFIG_DIR%/generic-resource-api-dg.properties' />
-                                        <parameter name='contextPrefix' value='prop' />
-                                    </execute>
-                                    <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >
-                                        <parameter name="templateFileName" value="`$prop.restapi.templateDir + '/actokentemplate.json'`" />
-                                        <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/controller/v2/tokens'`" />
-                                        <parameter name="format" value="json"/>
-                                        <parameter name="httpMethod" value="post"/>
-                                        <parameter name="responsePrefix" value="token-result"/>
-                                        <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>
-                                        <parameter name="trustStorePassword" value="adminadmin"/>
-                                        <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>
-                                        <parameter name="keyStorePassword" value="adminadmin"/>
-                                        <outcome value='success'>
-                                            <set>
-                                                <parameter name='prop.sdncRestApi.token_id' value='`$token-result.data.token_id`' />
-                                            </set>
-                                        </outcome>
-                                        <outcome value='failure'>
-                                            <block></block>
-                                        </outcome>
-                                    </execute>
-                                    <switch test="`$prop.sdncRestApi.token_id`">
-                                        <outcome value=''>
-                                            <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >
-                                                <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/data/ietf-network:networks'`" />
-                                                <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`" />
-                                                <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`" />
-                                                <parameter name="format" value="json"/>
-                                                <parameter name="httpMethod" value="get"/>
-                                                <parameter name="responsePrefix" value="topology"/>
-                                                <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>
-                                                <parameter name="trustStorePassword" value="adminadmin"/>
-                                                <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>
-                                                <parameter name="keyStorePassword" value="adminadmin"/>
-                                                <outcome value='failure'>
-                                                    <return status='failure'>
-                                                        <parameter name='ack-final' value='Y'/>
-                                                        <parameter name="error-code" value="500" />
-                                                        <parameter name="error-message" value="Error executing Create vpn rest api" />
-                                                    </return>
-                                                </outcome>
-                                                <outcome value='success'>
-                                                    <block atomic="true">
-                                                        <for index='nidx' start='0' end='`$topology.networks.network_length`' >
-                                                            <block>
-                                                                <set>
-                                                                    <parameter name='network.' value='`$topology.networks.network[$nidx].`' />
-                                                                </set>
-                                                                <call module='DataChange' rpc='update-network-to-aai' mode='sync' ></call>
-                                                            </block>
-                                                        </for>
-                                                    </block>
-                                                </outcome>
-                                            </execute>
-                                        </outcome>
-                                        <outcome value='Other'>
-                                            <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >
-                                                <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/data/ietf-network:networks'`" />
-                                                <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`" />
-                                                <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`" />
-                                                <parameter name="format" value="json"/>
-                                                <parameter name="httpMethod" value="get"/>
-                                                <parameter name="responsePrefix" value="topology"/>
-                                                <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>
-                                                <parameter name="trustStorePassword" value="adminadmin"/>
-                                                <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>
-                                                <parameter name="keyStorePassword" value="adminadmin"/>
-                                                <parameter name='customHttpHeaders' value="`'X-ACCESS-TOKEN=' + $prop.sdncRestApi.token_id`" />
-                                                <outcome value='failure'>
-                                                    <return status='failure'>
-                                                        <parameter name='ack-final' value='Y'/>
-                                                        <parameter name="error-code" value="500" />
-                                                        <parameter name="error-message" value="Error executing Create vpn rest api" />
-                                                    </return>
-                                                </outcome>
-                                                <outcome value='success'>
-                                                    <block atomic="true">
-                                                        <for index='nidx' start='0' end='`$topology.networks.network_length`' >
-                                                            <block>
-                                                                <set>
-                                                                    <parameter name='network.' value='`$topology.networks.network[$nidx].`' />
-                                                                </set>
-                                                                <call module='DataChange' rpc='update-network-to-aai' mode='sync' ></call>
-                                                            </block>
-                                                        </for>
-                                                    </block>
-                                                </outcome>
-                                            </execute>
-                                        </outcome>
-                                    </switch>
-                                </block>
-                            </outcome>
-                            <outcome value='Other'>
-                                <return status='failure'>
-                                    <parameter name='ack-final' value='Y'/>
-                                    <parameter name="error-code" value="500" />
-                                    <parameter name="error-message" value="`'Unsupported type = ' + $prop.sdncRestApi.type`" />
-                                </return>
-                            </outcome>
-                        </switch>
-                    </block>
-                </outcome>
-                <outcome value='delete'>
-                    <block atomic="true"></block>
-                </outcome>
-            </switch>
-        </block>
-    </method>
+<service-logic xsi:schemaLocation="http://www.onap.org/sdnc/svclogic ./svclogic.xsd" module="DataChange" version="${project.version}">\r
+    <method rpc="esr-thirdparty-sdnc-discovery" mode="sync">\r
+        <block atomic="true">\r
+            <switch test="`$prop.sdncRestApi.vendor == 'ZTE'`">\r
+                <outcome value="false">\r
+                    <switch test="`$data-change-notification-input.aai-event-trigger`">\r
+                        <outcome value="Update">\r
+                            <block>\r
+                                <switch test="`$prop.sdncRestApi.type`">\r
+                                    <outcome value="SOTN">\r
+                                        <block atomic="true">\r
+                                            <execute plugin="org.onap.ccsdk.sli.plugins.prop.PropertiesNode" method="readProperties">\r
+                                                <parameter name="fileName" value="%SDNC_CONFIG_DIR%/generic-resource-api-dg.properties"/>\r
+                                                <parameter name="contextPrefix" value="prop"/>\r
+                                            </execute>\r
+                                            <execute plugin="org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode" method="sendRequest">\r
+                                                <parameter name="templateFileName" value="`$prop.restapi.templateDir + '/actokentemplate.json'`"/>\r
+                                                <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/controller/v2/tokens'`"/>\r
+                                                <parameter name="format" value="json"/>\r
+                                                <parameter name="httpMethod" value="post"/>\r
+                                                <parameter name="responsePrefix" value="token-result"/>\r
+                                                <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>\r
+                                                <parameter name="trustStorePassword" value="adminadmin"/>\r
+                                                <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
+                                                <parameter name="keyStorePassword" value="adminadmin"/>\r
+                                                <outcome value="success">\r
+                                                    <set>\r
+                                                        <parameter name="prop.sdncRestApi.token_id" value="`$token-result.data.token_id`"/>\r
+                                                    </set>\r
+                                                </outcome>\r
+                                                <outcome value="failure">\r
+                                                    <block/>\r
+                                                </outcome>\r
+                                            </execute>\r
+                                            <switch test="`$prop.sdncRestApi.token_id`">\r
+                                                <outcome value="">\r
+                                                    <execute plugin="org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode" method="sendRequest">\r
+                                                        <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/data/ietf-network:networks'`"/>\r
+                                                        <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`"/>\r
+                                                        <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`"/>\r
+                                                        <parameter name="format" value="json"/>\r
+                                                        <parameter name="httpMethod" value="get"/>\r
+                                                        <parameter name="responsePrefix" value="topology"/>\r
+                                                        <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>\r
+                                                        <parameter name="trustStorePassword" value="adminadmin"/>\r
+                                                        <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
+                                                        <parameter name="keyStorePassword" value="adminadmin"/>\r
+                                                        <outcome value="failure">\r
+                                                            <return status="failure">\r
+                                                                <parameter name="ack-final" value="Y"/>\r
+                                                                <parameter name="error-code" value="500"/>\r
+                                                                <parameter name="error-message" value="Error executing Create vpn rest api"/>\r
+                                                            </return>\r
+                                                        </outcome>\r
+                                                        <outcome value="success">\r
+                                                            <block atomic="true">\r
+                                                                <for index="nidx" start="0" end="`$topology.networks.network_length`">\r
+                                                                    <block>\r
+                                                                        <set>\r
+                                                                            <parameter name="network." value="`$topology.networks.network[$nidx].`"/>\r
+                                                                        </set>\r
+                                                                        <call module="DataChange" rpc="update-network-to-aai" mode="sync"/>\r
+                                                                    </block>\r
+                                                                </for>\r
+                                                                <switch test="`$topology.networks.network_length >= 2`">\r
+                                                                    <outcome value="true">\r
+                                                                        <block atomic="true">\r
+                                                                            <for index="netidx" start="0" end="`$topology.networks.network_length`">\r
+                                                                                <block>\r
+                                                                                    <set>\r
+                                                                                        <parameter name="network." value=""/>\r
+                                                                                    </set>\r
+                                                                                    <set>\r
+                                                                                        <parameter name="network." value="`$topology.networks.network[$netidx].`"/>\r
+                                                                                    </set>\r
+                                                                                    <switch test="`$network.te-topology-id`">\r
+                                                                                        <outcome value="11">\r
+                                                                                            <block>\r
+                                                                                                <set>\r
+                                                                                                    <parameter name="network-otn." value="`$topology.networks.network[$netidx].`"/>\r
+                                                                                                </set>\r
+                                                                                            </block>\r
+                                                                                        </outcome>\r
+                                                                                        <outcome value="33">\r
+                                                                                            <block>\r
+                                                                                                <set>\r
+                                                                                                    <parameter name="network-eth." value="`$topology.networks.network[$netidx].`"/>\r
+                                                                                                </set>\r
+                                                                                            </block>\r
+                                                                                        </outcome>\r
+                                                                                    </switch>\r
+                                                                                </block>\r
+                                                                            </for>\r
+                                                                            <call module="DataChange" rpc="update-tp-ttp-relationship" mode="sync"/>\r
+                                                                        </block>\r
+                                                                    </outcome>\r
+                                                                </switch>\r
+                                                            </block>\r
+                                                        </outcome>\r
+                                                    </execute>\r
+                                                </outcome>\r
+                                                <outcome value="Other">\r
+                                                    <execute plugin="org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode" method="sendRequest">\r
+                                                        <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/data/ietf-network:networks'`"/>\r
+                                                        <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`"/>\r
+                                                        <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`"/>\r
+                                                        <parameter name="format" value="json"/>\r
+                                                        <parameter name="httpMethod" value="get"/>\r
+                                                        <parameter name="responsePrefix" value="topology"/>\r
+                                                        <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>\r
+                                                        <parameter name="trustStorePassword" value="adminadmin"/>\r
+                                                        <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
+                                                        <parameter name="keyStorePassword" value="adminadmin"/>\r
+                                                        <parameter name="customHttpHeaders" value="`'X-ACCESS-TOKEN=' + $prop.sdncRestApi.token_id`"/>\r
+                                                        <outcome value="failure">\r
+                                                            <return status="failure">\r
+                                                                <parameter name="ack-final" value="Y"/>\r
+                                                                <parameter name="error-code" value="500"/>\r
+                                                                <parameter name="error-message" value="Error executing Create vpn rest api"/>\r
+                                                            </return>\r
+                                                        </outcome>\r
+                                                        <outcome value="success">\r
+                                                            <block atomic="true">\r
+                                                                <for index="nidx" start="0" end="`$topology.networks.network_length`">\r
+                                                                    <block>\r
+                                                                        <set>\r
+                                                                            <parameter name="network." value="`$topology.networks.network[$nidx].`"/>\r
+                                                                        </set>\r
+                                                                        <call module="DataChange" rpc="update-network-to-aai" mode="sync"/>\r
+                                                                    </block>\r
+                                                                </for>\r
+                                                                <switch test="`$topology.networks.network_length >= 2`">\r
+                                                                    <outcome value="true">\r
+                                                                        <block atomic="true">\r
+                                                                            <for index="netidx" start="0" end="`$topology.networks.network_length`">\r
+                                                                                <block>\r
+                                                                                    <set>\r
+                                                                                        <parameter name="network." value=""/>\r
+                                                                                    </set>\r
+                                                                                    <set>\r
+                                                                                        <parameter name="network." value="`$topology.networks.network[$netidx].`"/>\r
+                                                                                    </set>\r
+                                                                                    <switch test="`$network.te-topology-id`">\r
+                                                                                        <outcome value="11">\r
+                                                                                            <block>\r
+                                                                                                <set>\r
+                                                                                                    <parameter name="network-otn." value="`$topology.networks.network[$netidx].`"/>\r
+                                                                                                </set>\r
+                                                                                            </block>\r
+                                                                                        </outcome>\r
+                                                                                        <outcome value="33">\r
+                                                                                            <block>\r
+                                                                                                <set>\r
+                                                                                                    <parameter name="network-eth." value="`$topology.networks.network[$netidx].`"/>\r
+                                                                                                </set>\r
+                                                                                            </block>\r
+                                                                                        </outcome>\r
+                                                                                    </switch>\r
+                                                                                </block>\r
+                                                                            </for>\r
+                                                                            <call module="DataChange" rpc="update-tp-ttp-relationship" mode="sync"/>\r
+                                                                        </block>\r
+                                                                    </outcome>\r
+                                                                </switch>\r
+                                                            </block>\r
+                                                        </outcome>\r
+                                                    </execute>\r
+                                                </outcome>\r
+                                            </switch>\r
+                                            <set>\r
+                                                <parameter name="input" value="ietf-subscribed-notifications:establish-subscription.input."/>\r
+                                                <parameter name="`$input + 'encoding'`" value="encode-json"/>\r
+                                            </set>\r
+                                            <execute plugin="org.onap.ccsdk.sli.plugins.restconfdiscovery.RestconfDiscoveryNode" method="establishSubscription">\r
+                                                <parameter name="subscriberId" value="sotn-controller"/>\r
+                                                <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/operations/ietf-subscribed-notifications:establish-subscription'`"/>\r
+                                                <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`"/>\r
+                                                <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`"/>\r
+                                                <parameter name="sseConnectURL" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/streams/yang-push-json'`"/>\r
+                                                <parameter name="dirPath" value="/opt/sdnc/restconfapi/yang/notification"/>\r
+                                                <parameter name="format" value="json"/>\r
+                                                <parameter name="httpMethod" value="post"/>\r
+                                                <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>\r
+                                                <parameter name="trustStorePassword" value="adminadmin"/>\r
+                                                <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
+                                                <parameter name="keyStorePassword" value="adminadmin"/>\r
+                                                <parameter name="customHttpHeaders" value="`'X-ACCESS-TOKEN=' + $prop.sdncRestApi.token_id`"/>\r
+                                                <parameter name="module" value="DataChange"/>\r
+                                                <parameter name="rpc" value="sotn-notification-handler"/>\r
+                                                <parameter name="mode" value="sync"/>\r
+                                            </execute>\r
+                                        </block>\r
+                                    </outcome>\r
+                                    <outcome value="TAPI">\r
+                                        <block atomic="true">\r
+                                            <execute plugin="org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode" method="sendRequest">\r
+                                                <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/cxf/tapi/v2/topologies?topology-id-or-name=otn'`"/>\r
+                                                <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`"/>\r
+                                                <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`"/>\r
+                                                <parameter name="format" value="json"/>\r
+                                                <parameter name="httpMethod" value="get"/>\r
+                                                <parameter name="responsePrefix" value="topologies"/>\r
+                                                <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.tapi.jks"/>\r
+                                                <parameter name="trustStorePassword" value="adminadmin"/>\r
+                                                <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
+                                                <parameter name="keyStorePassword" value="adminadmin"/>\r
+                                                <outcome value="failure">\r
+                                                    <return status="failure">\r
+                                                        <parameter name="ack-final" value="Y"/>\r
+                                                        <parameter name="error-code" value="500"/>\r
+                                                        <parameter name="error-message" value="Error executing get topology TAPI rest api"/>\r
+                                                    </return>\r
+                                                </outcome>\r
+                                                <outcome value="success">\r
+                                                    <block atomic="true">\r
+                                                        <for index="tidx" start="0" end="`$topologies.topology_length`">\r
+                                                            <block>\r
+                                                                <set>\r
+                                                                    <parameter name="topology." value="`$topologies.topology[$tidx].`"/>\r
+                                                                </set>\r
+                                                                <call module="DataChange" rpc="tapi-update-network-to-aai" mode="sync"/>\r
+                                                            </block>\r
+                                                        </for>\r
+                                                    </block>\r
+                                                </outcome>\r
+                                            </execute>\r
+                                        </block>\r
+                                    </outcome>\r
+                                    <outcome value="MSA">\r
+                                        <block atomic="true">\r
+                                            <execute plugin="org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode" method="sendRequest">\r
+                                                <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/cxf/openroadm/v2/networks/otn-topology'`"/>\r
+                                                <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`"/>\r
+                                                <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`"/>\r
+                                                <parameter name="format" value="json"/>\r
+                                                <parameter name="httpMethod" value="get"/>\r
+                                                <parameter name="responsePrefix" value="networks"/>\r
+                                                <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.msa.jks"/>\r
+                                                <parameter name="trustStorePassword" value="adminadmin"/>\r
+                                                <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
+                                                <parameter name="keyStorePassword" value="adminadmin"/>\r
+                                                <outcome value="failure">\r
+                                                    <return status="failure">\r
+                                                        <parameter name="ack-final" value="Y"/>\r
+                                                        <parameter name="error-code" value="500"/>\r
+                                                        <parameter name="error-message" value="Error executing get topology MSA rest api"/>\r
+                                                    </return>\r
+                                                </outcome>\r
+                                                <outcome value="success">\r
+                                                    <block atomic="true">\r
+                                                        <call module="DataChange" rpc="msa-update-network-to-aai" mode="sync"/>\r
+                                                    </block>\r
+                                                </outcome>\r
+                                            </execute>\r
+                                        </block>\r
+                                    </outcome>\r
+                                    <outcome value="Other">\r
+                                        <return status="failure">\r
+                                            <parameter name="ack-final" value="Y"/>\r
+                                            <parameter name="error-code" value="500"/>\r
+                                            <parameter name="error-message" value="`'Unsupported type = ' + $prop.sdncRestApi.type`"/>\r
+                                        </return>\r
+                                    </outcome>\r
+                                </switch>\r
+                            </block>\r
+                        </outcome>\r
+                        <outcome value="Delete">\r
+                            <block atomic="true">\r
+                                <switch test="`$prop.sdncRestApi.type`">\r
+                                    <outcome value="MSA">\r
+                                        <block atomic="true">\r
+                                            <set>\r
+                                                <parameter name="controllerid" value="`$prop.sdncRestApi.type + '_' + $prop.sdncRestApi.thirdpartySdnc.url + '_' + $prop.sdncRestApi.thirdpartySdnc.id`"/>\r
+                                            </set>\r
+                                            <get-resource plugin="org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource" resource="SQL" key="SELECT controller_id from TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE WHERE controller_id = $controllerid" pfx="dbcontrollerid">\r
+                                                <outcome value="success">\r
+                                                    <delete plugin="org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource" resource="SQL" key="DELETE FROM TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE WHERE controller_id = $controllerid"/>\r
+                                                </outcome>\r
+                                                <outcome value="failure">\r
+                                                    <return status="failure">\r
+                                                        <parameter name="ack-final" value="Y"/>\r
+                                                        <parameter name="error-code" value="500"/>\r
+                                                        <parameter name="error-message" value="Failure in getting controller-id from DB"/>\r
+                                                    </return>\r
+                                                </outcome>\r
+                                                <outcome value="not-found">\r
+                                                    <return status="failure">\r
+                                                        <parameter name="ack-final" value="Y"/>\r
+                                                        <parameter name="error-code" value="500"/>\r
+                                                        <parameter name="error-message" value="controller-id could not be found in DB"/>\r
+                                                    </return>\r
+                                                </outcome>\r
+                                            </get-resource>\r
+                                        </block>\r
+                                    </outcome>\r
+                                    <outcome value="TAPI">\r
+                                        <block>\r
+                                            <set>\r
+                                                <parameter name="controllerid" value="`$prop.sdncRestApi.type + '_' + $prop.sdncRestApi.thirdpartySdnc.url + '_' + $prop.sdncRestApi.thirdpartySdnc.id`"/>\r
+                                            </set>\r
+                                            <get-resource plugin="org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource" resource="SQL" key="SELECT controller_id from TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE WHERE controller_id = $controllerid" pfx="dbcontrollerid">\r
+                                                <outcome value="success">\r
+                                                    <delete plugin="org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource" resource="SQL" key="DELETE FROM TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE WHERE controller_id = $controllerid"/>\r
+                                                </outcome>\r
+                                                <outcome value="failure">\r
+                                                    <return status="failure">\r
+                                                        <parameter name="ack-final" value="Y"/>\r
+                                                        <parameter name="error-code" value="500"/>\r
+                                                        <parameter name="error-message" value="Failure in getting controller-id from DB"/>\r
+                                                    </return>\r
+                                                </outcome>\r
+                                                <outcome value="not-found">\r
+                                                    <return status="failure">\r
+                                                        <parameter name="ack-final" value="Y"/>\r
+                                                        <parameter name="error-code" value="500"/>\r
+                                                        <parameter name="error-message" value="controller-id could not be found in DB"/>\r
+                                                    </return>\r
+                                                </outcome>\r
+                                            </get-resource>\r
+                                        </block>\r
+                                    </outcome>\r
+                                    <outcome value="Other">\r
+                                        <return status="failure">\r
+                                            <parameter name="ack-final" value="Y"/>\r
+                                            <parameter name="error-code" value="500"/>\r
+                                            <parameter name="error-message" value="`'Unsupported type = ' + $prop.sdncRestApi.type`"/>\r
+                                        </return>\r
+                                    </outcome>\r
+                                </switch>\r
+                            </block>\r
+                        </outcome>\r
+                    </switch>\r
+                </outcome>\r
+                <outcome value="true">\r
+                    <call module="DataChange" rpc="esr-thirdparty-sdnc-of-zte" mode="sync"/>\r
+                </outcome>\r
+            </switch>\r
+        </block>\r
+    </method>\r
 </service-logic>
\ No newline at end of file