select "ID","GUID","STATE","INVOICE_NR","CREATEDTIME","CREATEDBY","MODIFIEDTIME","MODIFIEDBY","ENTITYVERSION"
  from json_table(HttpURItype('http://crldev.tecna.pl:8078/rest/api/Invoices').getclob(),
                  '$[*]'
                  columns (
                  id number path '$.Id',
                  guid varchar2(38) path '$.GUID',
                  state varchar2(10) path '$.State',
                  Invoice_Nr varchar2(40) path '$.Number',
                  CreatedTime varchar2(24) path '$.CreatedTime',
                  CreatedBy varchar2(20) path '$.CreatedBy',
                  ModifiedTime varchar2(24) path '$.ModifiedTime',
                  ModifiedBy varchar2(20) path '$.ModifiedBy',
                  EntityVersion number path '$.EntityVersion'
                  )
                )




select "BANKINGINFOSGUID","ACCOUNTNO","BANKNAME","ACCOUNTNAME","ACTIVE","SWIFT_BIC","ST_LAST_MODIFIED","SHORTCUT","NAME","BANKINGINFOGUID","GUID","POZYCJA"
  from json_table(HTTPURITYPE.CREATEURI(get_param_value('url_rest') || '/Accounts/').getClob(),
                  '$[*]'
                  columns (
                  BankingInfosGuid varchar2(40) path '$.BankingInfosGuid',
                  AccountNo varchar2(50) path '$.AccountNo',
                  BankName varchar2(100) path '$.BankName',
                  AccountName varchar2(100) path '$.AccountName',
                  Active varchar2(6) path '$.Active',
                  SWIFT_BIC varchar2(11) path '$.SWIFT_BIC',
                  st_last_modified varchar2(40) path '$.St_last_modified',
                  Shortcut varchar2(50) path '$.Shortcut',
                  Name varchar2(150) path '$.Name',
                  BankingInfoGuid varchar2(40) path '$.BankingInfoGuid',
                  Guid varchar2(40) path '$.Guid',
                  pozycja number path '$.pozycja'
                  )
    ) where SET_BODY_CHARSET = 1