Build a Master/Detail using VBCS Excel Add-In and ORDS
Summary:
Is it possible to use the ORDS service to build an Master/Detail using VBCS Excel Add-In
Content (required):
I have a ORDS service that returns the data using the below SQL. In the Handler the Source Type is set to Media and the Source is set to the below SQL
SELECT
'application/json',
JSON_OBJECT (
'legal_entity_identifier' VALUE cpg.legal_entity_identifier,
'cpg_id' VALUE cpg.cpg_id,
'cpg_code' VALUE cpg.cpg_code,
'cpg_name' VALUE cpg.cpg_name,
'price_grp_lines' VALUE (
SELECT
JSON_ARRAYAGG(JSON_OBJECT(
'cpg_line_id' VALUE cpgl.cpg_line_id,
Tagged:
0