Thanks Anurag for your reply.
One more question Can I return some value from A and use in B?

Thanks

Hello,

I have created one engagement designer application with the name 'A' that performs some database query and gives the result.
Now, I want to use my engagement designer application with the name 'A' in other engagement designer application say in 'B'.

So, how can I achieve this functionality.


Thanks in advance.

One more question guys.

In Read From DB task, I am getting below error

" Error getting Input schema for Read DB task:
java.sql.SQLFeatureNotSupportedException:Unsuported Feature"

For some table I am getting above exception and other are working fine.

Hi Jack,

Yes, I have successfully tested function in Oracle directly and it return row data

Hello Rajesh and Jack,

I am using oracle DB. I have try to execute simple function from Read DB task but I am getting the below exception when retrieve Output Schema

"Error getting output schema for Read DB task:
java.lang.IllegalStateException: Failed to get resultSet metaData from SQL: Select TotalRecords()"

FYI , I have successfully test database connection with validation query.

Please let me know your thoughts.

Thanks

Thanks Anurag for your help.

One more question you know about the 'READ FROM DB' task.

When I Drag and Drop Read DB task, there is nothing listed in the db profile drop down.

Thanks

How can I write json schema for output value. You have some example how to do this , that will be great.

Thanks Anurag for replying,

So can I pass my xml data in the input of service and retrieve output data in xml.

Or I need to convert my xml data to json before sending request.

Thanks

Hello,

Can we call Soap service (WSDL) in Engagement Designer application like calling Rest Service.

Thanks

Hello All,

I have rest service that invokes Engagement Designer application.

Is there a way that we can call rest service from Avaya experience portal.
Reason behind this, I want to call my Engagement Designer application through Avaya experience portal.

Thanks in advance

Ok Joel, I will post my question Orhcestration Designer forum.

One more quetion can we call Soap service (WSDL) in Engagement Designer application like calling Rest Service.

Thanks for your help.

Thanks Joel,

You know how to invoke REST APIs from Experience portal or is there someone who can help me.

Please let me know

Thanks

Hi Bill,

Thanks for replying 'configured my database in Avaya System manager' means , I have added JDBC Provider in System manager.
Also, I am using Oracle DB. Also, I am able to access it through client tools.

Below are the details of JDBC Providers:

Name: Test
ClassName: oracle.jdbc.xa.client.OracleXADataSource
JarFile: Ojdbc7.jar

Please let me know your thougts

Thanks

Hi,

I have configured my database in Avaya System manager. Also Created JDBC data source for my database under Configuration.
When I click on 'Test Connection' button , Getting "Array index out of range: -1".
Right now, I am not using any Validation query inside JDBC data source But still getting same error.

I have also try with Validation query inside JDBC data source, but getting same error.

I have also attached the screenshot of error.

Please suggest me right path.

Thanks in advance.

Hi Joel,

Thanks, for replying.

I have check the attached file.In that file, they have call the engagement designer application through postman.
I also know how to call engagement designer application through postman. But I want to call my engagement designer application through Avaya Experience portal. The reason behind to call my engagement designer application through Avaya Experience portal is, I want reporting of my Engagement designer application like OD application in AEP.

So please suggest me right path on this.

Thanks