Not able to get the result of sql query

0
Dear Mendix Team, Goal: Connect an external oracle database, execute a select query, get the result and make the REST call using the query result. Issue: Since It’s an external database, I don’t have domain model here then what I need to give the value of “Result Object” as part Execute Query Parameter. Can you please help me on this? Thanks in advance.
asked
1 answers
1

Hi Suraj

I don’t have a domain model here then what I need to give the value of “Result Object” as part of Execute Query Parameter.

You have to create an entity with the same attribute as your database table has and in microflow create an empty object of that entity and pass it as a result object. this is based on your use-case 

select * from <table_name>

 

The result object holds the query result data and should have the same attribute (name should be the same as the query result) as your target table schema.

assume you select  partial data (attribute) from the table then you just need to create an entity with these attributes.

 

 

 

 

 

answered