Manual Object creation from database

0
How to create a Mendix object manually via query from database using insert query?
asked
3 answers
0

Hi chandra ,                    

If you can use Mendix’s standard approach, here’s how you would create and save a person object:

  1. Create an Object in a Microflow:

    This would be the Mendix-native way to create an object rather than using a raw SQL Insert 

Create a Person object using the   create object action.

  • Set the attributes (Name,Age,email,etc...) of the object.
  • Commit the object using the    commit action.
answered
0

Hello Chandra P,

  1. Can you try to expose the existing application data via REST API.
  2. Fetch data using pagination 
  3. Process the payload and add validation to the payload to prevent duplication
  4. Finally store the data in the Mendix app

I think this will helpful! 

answered
0

Hi Chandra ,

     This is the query to insert the object inside the database

     INSERT INTO "PUBLIC"."poc$project"( "id", "projectcode", "projectname" )VALUES ( 123456789876543, 'Pro00022', 'Project45')

     in this case project is my entity and it has three attribute your case right click the table and click insert and after VALUES() you need to fill the data manually as per above query and give the "id" is 16 digit object id then click Execute SQL button the object will create manually in database.

 

Hope it helps

Thank you.

answered