Skip to main content
Solved

Single GET method to return ALL the columns from both parent and child Entities (custom logical units) from a Custom Projection

  • January 10, 2023
  • 3 replies
  • 148 views

Forum|alt.badge.img+3

Hi all,

Are there any possibilities to generate a single GET method to return ALL the columns from both parent and child Entities (custom logical units) from a Custom Projection?

 

Best Regards

Rahulan Mahendra

Best answer by Jonas Feigl

@Rahulan Mahendra Ah this is on Apps10. Unfortunately using Query Designer is then not an option. Having said that you should still be able to create a Quick Report that contains the data you need. That Quick Report will automatically be exposed as a REST API which should allow you to do what you need. You do not have to do any Projection Configuration for this to work.

And yes, Quick Reports (as well as Query Designer in IFS Cloud) can be consumed in integrations as well.

One important note: The ID of the Quick Report is a randomly generated number and this number is part of the REST API Endpoint Name. To make sure the endpoint has the same name on all of your environments (i.e. TEST, PROD, etc.) make sure to transfer the Quick Report between environments using an ACP (Application Configuration Package) rather than manually creating the Quick Report on each environment.

View original
Did this topic help you find an answer to your question?

3 replies

Jonas Feigl
Superhero (Employee)
Forum|alt.badge.img+20
  • Superhero (Employee)
  • 261 replies
  • January 11, 2023

@Rahulan Mahendra Is this for integration purposes or what exactly are you trying to achieve?

If the data needs to just be readable you could use the Query Designer to combine the data of your two entities or if you are not on 22R2 yet a quick report might be another option as these get exposed as REST APIs as well.


Forum|alt.badge.img+3

@Jonas Feigl 

Customer will eventually use the API with our boomi integration, but their main goal is to get a SINGLE GET method from the Custom Projection's API to return ALL columns in the table.

Is there any other way to achieve this in App 10 aurena from custom projection? 

Will the above method work for integration as well?

 


Jonas Feigl
Superhero (Employee)
Forum|alt.badge.img+20
  • Superhero (Employee)
  • 261 replies
  • Answer
  • January 12, 2023

@Rahulan Mahendra Ah this is on Apps10. Unfortunately using Query Designer is then not an option. Having said that you should still be able to create a Quick Report that contains the data you need. That Quick Report will automatically be exposed as a REST API which should allow you to do what you need. You do not have to do any Projection Configuration for this to work.

And yes, Quick Reports (as well as Query Designer in IFS Cloud) can be consumed in integrations as well.

One important note: The ID of the Quick Report is a randomly generated number and this number is part of the REST API Endpoint Name. To make sure the endpoint has the same name on all of your environments (i.e. TEST, PROD, etc.) make sure to transfer the Quick Report between environments using an ACP (Application Configuration Package) rather than manually creating the Quick Report on each environment.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings