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_id

                       and rn.assortment_id = ra.assortment_id

                       and ra.char_code in

                           ('EPD_RESOURCE_ID',

                            'GENERIC_GWP',

                            'PRODUCT_SECURITY_SHEET',

                            'PRODUCT_DATA_SHEET',

                            'PRODUCT_DECLARATION_SHEET',

                            'ARTICLE_IMAGE_SINGLE'))

                   ) as parts

  from retwho_assortment_node rn

 where part_no is not null

   and leaf_state_db = 'Active'

   AND rownum = 1;

BEGIN            

  OPEN get_attr_value ;

  FETCH get_attr_value  INTO json_clob_ ;

  close get_attr_value ;

  Plsqlap_Server_API.Post_Outbound_BizAPI(

         bizapi_name_  => 'PART_INFO',  

         xml_          => json_clob_,

         sender_       => 'IFS',

         subject_      => 'Part Info Message',

         receiver_     => 'AWS',

         message_type_ => 'xx',

         message_id_   => message_id_);  

end;