Question Re: Mapping a rest API response in Build Apps in Technology Q&A

Mapping a rest API response in Build Apps

souvikroy — Tue, 01 Aug 2023 02:42:59 GMT

I am consuming a REST API in Build App and need to map few fields from data collection and as well as msgs.count from collections collection as shown in below images.

I have added below code in Response mapper to map fields from the data collection and created an entity.

{ records: response.data.data , driverCode: response.status }

Is it possible to map the msgs.count from collections collection as well in the same entity along with other fields from data collection from the rest API?

Re: Mapping a rest API response in Build Apps

Dan_Wroblewski — Tue, 01 Aug 2023 05:02:03 GMT

the JSON you show all comes from same response, I assume?

can you show what you want to end up with?

Re: Mapping a rest API response in Build Apps

souvikroy — Tue, 01 Aug 2023 05:25:37 GMT

Hi Daniel,

Yes,it comes from same API call json response.

I need to display a list report with the below columns. I also added their mapping.

I will be using Row component and would like to repeat the data rows on the data variable for display.

Re: Mapping a rest API response in Build Apps

MarcHuber — Tue, 01 Aug 2023 06:34:22 GMT

With { records: response.data.data , driverCode: response.status } you are filtering the results for the data entity of your api call. Just remove the response mapper. Afterwards you will have access to also to the collections entity.

Best regards,

Marc

Re: Mapping a rest API response in Build Apps

Dan_Wroblewski — Tue, 01 Aug 2023 07:10:04 GMT

I am assuming this question is related to the other question you entered.

So you could:

Do the data manipulation here, in the data resource.
Do the the data manipulation in a set data variable flow function to reset the data variable.
Do the data manipulation before the binding.

It depends which data you will need and when.

Re: Mapping a rest API response in Build Apps

souvikroy — Tue, 01 Aug 2023 15:36:17 GMT

Hi Marc, Thanks for your reply. The reason I added the response mapper, so that I can bind the response with the list report correctly otherwise, I will not be able to bind the response to a data variable to repeat it as list.

Re: Mapping a rest API response in Build Apps

souvikroy — Tue, 01 Aug 2023 15:39:34 GMT

Hi daniel.wroblewski I was able to manipulate in a set variable flow function . Can you please guide me, how we can map/manipulate in the data resource itself.

Note: The API is a standard API and I will not be able to manipulate the response layout of the API.

Re: Mapping a rest API response in Build Apps

Dan_Wroblewski — Tue, 01 Aug 2023 16:11:33 GMT

To manipulate in the data resource, you would take your formula you used (and Marc rightly said was unnecessary above) but now use it and add functions to manipulate the data, now that you want to manipulate here.

Just as an example, I took Northwind and set the retrieve to return the first record.

Then I added this to the response mapper ...

{ records: PICK_KEYS(response.data,["CustomerID", "City"]), driverCode: response.status }

... so that it returned the same record but with fewer fields.

You can do whatever you need in the formula.

Re: Mapping a rest API response in Build Apps

vikas_992001 — Tue, 01 Aug 2023 16:51:59 GMT

Hi Souvik,

Please see my response in this one. Hope this will work for you.

https://answers.sap.com/answers/13938600/view.html

Re: Mapping a rest API response in Build Apps

Ben_Samuel — Thu, 02 May 2024 03:24:22 GMT

Thanks Marc,

it works for me and i can bind it correctly