Question Re: Binding Nested JSON Model in XML View in Technology Q&A

Binding Nested JSON Model in XML View

huibin_lau — Thu, 16 Aug 2018 14:45:58 GMT

Hi Experts,

I have a nested JSON model named salesOrderModel as below and I am trying to bind it to a list in a XML view to display all the product names in the "products" array.

{
	"orders": [
		{
			"orderId": 0,
			"orderName": "Order 1",
			"products": [
				{
					"productId": 0,
					"productName": "Product 1-A"
				},
				{
					"productId": 1,
					"productName": "Product 1-B"
				},
				{
					"productId": 2,
					"productName": "Product 1-C"
				},
				{
					"productId": 3,
					"productName": "Product 1-D"
				},
				{
					"productId": 4,
					"productName": "Product 1-F"
				}
			]
		}
	]
}

I am doing the binding in the XML view as below

<View
	xmlns="sap.m"
	xmlns:layout="sap.ui.layout"
	controllerName="test.View1">
	<Page
		title="{salesOrderModel>orderName}"
		navButtonPress="onNavBack"
		showNavButton="{device>/system/phone}">
		<content>
					<List id="products" 
						items="{salesOrderModel>/orders}"
						headerText="Products">
					<items>
						<StandardListItem title="{salesOrderModel>products/productName}" 
							type="Active"
							press="onSelectionChange"/>
					</items>
				</List>
		</content>
	</Page>
</View>

The binding path at runtime is incorrect.

How can I correct the path and display the correct information? Thanks.

Regards,

Hui Bin

Re: Binding Nested JSON Model in XML View

SergioG_TX — Thu, 16 Aug 2018 14:48:44 GMT

you should bind your List to the orders/products rather than the orders

						items="{salesOrderModel>/orders/products}"

then in your items remove products since you have binded that already

<StandardListItem title="{salesOrderModel>/productName}"

Re: Binding Nested JSON Model in XML View

huibin_lau — Thu, 16 Aug 2018 16:13:42 GMT

Hi Sergio Guerrero,

I tried exactly as you said but at runtime the path is invalid.

Any idea what's wrong?

Re: Binding Nested JSON Model in XML View

junwu — Fri, 17 Aug 2018 01:27:05 GMT

items="{salesOrderModel>/orders/0/products}"

<StandardListItem title="{salesOrderModel>productName}" type="Active"
							press="onSelectionChange"/>

Re: Binding Nested JSON Model in XML View

huibin_lau — Fri, 17 Aug 2018 05:47:39 GMT

I figured the solution out, thanks your comment helped!

Re: Binding Nested JSON Model in XML View

former_member450404 — Thu, 20 Jun 2019 05:23:16 GMT

so what was the solution ? huibin.lau

Re: Binding Nested JSON Model in XML View

former_member601269 — Thu, 20 Jun 2019 12:14:34 GMT

Hi huibin.lau,

The problem is in items give it as items="{salesOrderModel>/orders/0/products}"

and in standardListItem Title give it as title="{salesOrderModel>productName}"

and all these are case-sensitive if error is coming means its because of this reason.

please let me know once you have done.