on 2019 Jul 26 11:55 AM
Hi Everyone,
I have BLS that converting a sql query results to json output. Everything working fine with multiple rows.
But if the query returns only one row in the results, json array Square brackets are not being generated. As you can see samples below. So the binding path of json model is changing in our ui5 application. I'm looking for a workaround.
Thank you.
Results For two row:
{
},
}
]
}
}
}
Results For One Row:
{
}
}
}
}
What are you using to do the conversion? If you are using the XML to Json Converter Action you may have issues because it is meant as a generic conversion and not specifically for the MII Rowset format. The conversion engine has no way to know if an xml node is meant to be an array or not unless it finds more than one duplicate child node/record.
I typically keep things within the bls engine xml and wrap my transactions with an Xacute query to do the conversion to json when calling from the front end. The downside of this is that you have to have your output in the Rowsets format but the upside is that you will always get the correct json format.
Regards,
Christian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.