create API To execute function.

usr338

Hello, I have two application which second one in based on first one. I need some data that exist in second application and i can't reach it in first one.
I though may be i can create API in second app and make a REST call in first app to get data from there. but I need to execute function in second function to generate data and save them in a table to be accessed through API.
Is there any way to execute function when API is called instead on dirctly accessing relation data ?
by returning result of function instead on relation data in API , we can implement our custom logic on data before fetched or posted.

gabriel

Using APIs like that is possible but really cumbersome and slow. Why can´t you access data from your 1st app (parent) if your second app (child) is built on top of it? You should have access to all parent relations from the child.

If you need access to child relations from the parent (eg. the other way around), then you could redesign your relation structure so that the shared data is accessible to both apps inside the parent. This would save you a lot of work & headaches in the future. You can do that in existing apps by creating new structures, reimporting data into them and then deleting the old structures.

Going through APIs everytime your data access does not work because of a badly designed structure, will get expensive very fast as API exchange always has overhead and can get complicated when conflicts occur.

But to directly answer your question: You would need to call another API first by creating a record, which executes a backend function via trigger, which can do whatever you need. The filled relation can then be retrieved via a 2nd API. It is currently not possible to directly execute a backend function via API without executing a trigger in some fashion.

usr338

gabriel Thank you Gabriel for response. actually i need to access some data in child app from parent. and because this data produced in child app (it should use logic and relations in child app), it can not be shared in parent app.
As creating record with api (even for 'ge't call) to trigger executing a function and calling second api, is complicated (and my be cause some problem in synchronization), i consider changing my apps design. tanx.
One solution that looks like a hack, is that in the form of the parent app that i need calculated data in child app, i can open form in child app that can access all data in child app and parent app.

gabriel

Moving structures / logic / interfaces from children to their parents for shared access is often the best solution. Sometimes, it even makes sense to create a new parent app, that both current child and parent apps build on.

Another option but not always a great one: You can make the parent build on the child as well - eg. both apps build on each other. This allows access from/to both apps. The downside: You can never again just install the parent app alone - the child app will always be installed as well.

As an example of this in practice: The apps "REI3 Tasks" & "REI3 Projects" build on each other - we call that a "circular dependency". Both apps can access each other - but because of that neither can be installed without the other.