Topics started by arwid

1 Topic

A
Do Gooder (Partner)
arwidDo Gooder (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Send .json file http application message

Hi,Im trying to send a file in json format, destinatiion http. Im almost there but my problem is that I get the .xml extension to my file. One soluton would problably be to create xml file when transform to json, but since it is in this case easier to create the json directly using  json_object select into a clob and then send the clob as application message I want to find a way to send as filename with .json. Any suggestions?IFS 10, Upd 16. Code example:declare   json_clob_  CLOB;  message_id_ NUMBER;    cursor get_attr_value is  select json_object('partNo' is rn.part_no,                   'partDescription' is assort_node_desc,                   'attributes' is                   (select json_arrayagg(json_object('attribute' is                                                     ra.char_code,                                                     'value' is ra.value))                      from RETWHO_ASSORT_NODE_CHAR ra                     where rn.assortment_node_id = ra.assortment_node_

0
A
Do Gooder (Partner)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings