Replies posted by flestephs

15 Replies

RohitSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Cannot create a simple JSON using PLSQLAP_Document_API

I have copied/modified the to_json method to get rid of of the “ArrayElement” Objects: PROCEDURE To_Json___ ( json_ OUT CLOB, main_ IN Plsqlap_Document_API.Document, agg_level_ IN BOOLEAN DEFAULT TRUE, indent_ IN NUMBER DEFAULT NULL, use_crlf_ IN BOOLEAN DEFAULT FALSE)IS nl_ VARCHAR2(2); buf_ VARCHAR2(32767); PROCEDURE Append(str_ VARCHAR2) IS BEGIN buf_ := buf_ || str_; EXCEPTION WHEN value_error THEN Dbms_Lob.WriteAppend(json_, length(buf_), buf_); buf_ := str_; END; FUNCTION Encode_Clob_Value (value_ IN CLOB) RETURN CLOB IS BEGIN RETURN replace(replace(replace(replace(replace(replace(replace(value_,chr(8),'\b'),chr(9),'\t'),chr(10),'\n'),chr(12),'\f'),chr(13),'\r'),chr(34),'\"'),chr(92),'\\'); END; FUNCTION Encode_Text_Value (value_ IN VARCHAR2) RETURN VARCHAR2 IS BEGIN RETURN replace(replace(replace(replace(replace(replace(replace(value_,chr(8),'\b'),chr(9),'\t'),chr(10)

23 days ago

RohitSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Cannot create a simple JSON using PLSQLAP_Document_API

Problem with aggregation level: Plsqlap_Document_API.Clear(doc_); doc_ := Plsqlap_Document_API.New_Document('MAIN_DOC'); Plsqlap_Document_API.Add_Attribute(doc_, 'SomeElement', 'Honey', null); array_id_ := Plsqlap_Document_API.Add_Array(doc_, 'Array', null); FOR i IN 1..3 LOOP array_elem_id_ := Plsqlap_Document_API.Add_Document(doc_, 'ArrayElement' , array_id_); Plsqlap_Document_API.Add_Attribute(doc_, 'ArrayElement', i, array_elem_id_); END LOOP; Plsqlap_Document_API.To_Json(json_, doc_); The Result is:{ "MAIN_DOC" : { "SomeElement" : "Honey", "Array" : [ { "ArrayElement" : { "SomeElementInArray" : 1 } }, { "ArrayElement" : { "SomeElementInArray" : 2 } }, { "ArrayElement" : { "SomeElementInArray" : 3 } } ] }} But the receiving REST API needs it like this:{ "SomeElement" : "Honey", "Array" : [ { "SomeEl

23 days ago

RohitSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Cannot create a simple JSON using PLSQLAP_Document_API

PROCEDURE Remove_Outer_Json_Node___ ( json_ IN OUT NOCOPY CLOB, raise_error_ IN BOOLEAN DEFAULT TRUE )IS json_ele_ JSON_ELEMENT_T; json_obj_ JSON_OBJECT_T; json_arr_ JSON_ARRAY_T; json_keys_ JSON_KEY_LIST;BEGIN IF (json_ IS NULL OR json_ = empty_clob OR Dbms_Lob.GetLength(json_) = 0) THEN IF (raise_error_) THEN Error_SYS.Appl_General(lu_name_, 'JSON_ERR1: Could not remove outer node from JSON as it is empty.'); ELSE RETURN; END IF; END IF; json_ele_ := JSON_ELEMENT_T.parse(json_); IF (json_ele_.Is_Object()) THEN json_obj_ := TREAT(json_ele_ AS JSON_OBJECT_T); json_keys_ := json_obj_.Get_Keys; IF (json_keys_.COUNT <> 1) THEN IF (raise_error_) THEN Error_SYS.Appl_General(lu_name_, 'JSON_ERR2: Could not remove outer node from JSON as multiple keys exist.'); ELSE RETURN; END IF;

23 days ago

RohitSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Cannot create a simple JSON using PLSQLAP_Document_API

I have the same issue. I have solved it by manually deleting the “outer json node” after generating the json.There is furthermore the problem, that it is not possible to remove aggregation level. In the to_xml method it can be set to FALSE, but in to_json there is no such option.I had to make a copy of the to_json method and implement it myself.

23 days ago

flestephsDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Customizing Navigator with parent entry

It seems, that puting the parent navigator entry in any other custom client file is working. Seems that customizing the SrvconNavigator.client is somehow treated specially...

6 months ago

hhy38Hero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to use URL parameter in Routing Address?

@ashen_malaka_ranasinghe Where can I find the value, the placeholder is replaced with? The Application Message does not show it (or I just cant find it?).Maybe this will help hh38 to find the error.

6 months ago

hhy38Hero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to use URL parameter in Routing Address?

Edit: I found the problem in my Example above:I usedPLSQLAP_DOCUMENT_API.Add_Attribute(url_,'parameter1','/posts'); but it has to bePLSQLAP_DOCUMENT_API.Add_Attribute(url_,'parameter1','posts'); I will now try my customization instead of this simple plsql example.

6 months ago

hhy38Hero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to use URL parameter in Routing Address?

My konfiguration is like this: Executing my test script:DECLARE xml_doc_ Plsqlap_Document_API.Document; url_ Plsqlap_Document_API.Document; json_structure_ VARCHAR2(32000) := 'TEST'; url_param_attr_ VARCHAR2(32000); json_ clob;BEGIN --url_ := PLSQLAP_DOCUMENT_API.New_Document('url_params'); --PLSQLAP_DOCUMENT_API.Add_Attribute(url_,'parameter1','/posts'); xml_doc_ := Plsqlap_Document_API.New_Document('TEST_DOC'); Plsqlap_Document_API.Add_Attribute(xml_doc_, 'title', 'foo'); Plsqlap_Document_API.Add_Attribute(xml_doc_, 'body', 'bar'); Plsqlap_Document_API.Add_Attribute(xml_doc_, 'userId', '1'); Plsqlap_Document_API.To_Json(json_, xml_doc_); Plsql_Rest_Sender_API.Call_Rest_EndPoint2(rest_service_ => 'FLESTEPHS_REST_TEST', xml_ => json_, --url_params_ => url_,

6 months ago

hhy38Hero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to use URL parameter in Routing Address?

Hello, I have read the documentation a few times too, but no success so far.I am working on Cloud 22.2.6

6 months ago

hhy38Hero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to use URL parameter in Routing Address?

Hello, I have the same problem. I have defined base URL in Routing Address with {parameter1} placeholder. But it gets not replaced when sending Application Message.

6 months ago

flestephsDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Optional assistant input parameter

Any clues what the “supported way” looks like?

8 months ago

flestephsDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IAL is not executed

Thanks, after resetting the “Failed Executions” it works again.

2 years ago

flestephsDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IAL is not executed

IAL is running for now I don’t know why it failed in the first place, but it’s a success for now.I also checked PROD and there is 1 Failed Execution there - also unknown to me why - no error background job there. I will monitor the running IAL on TEST for errors now.

2 years ago

flestephsDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IAL is not executed

Thanks,I cant find any IAL Background Job with Status Error The 2 Failed might come from me breaking the manual run few days ago. Now status is always POSTED, not OK or ERROR.I have increased the System Parameter to 5 to be sure and scheduled another run for 10:15 am. I also will copy SQL and create a copy of that IAL

2 years ago

flestephsDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IAL is not executed

Thank you all for the information.I have created new test IAL C_TEST with 10 min intervall, it is working. So basically IAL Backgroundjobs are working: But the customers IAL (C_TRACE_DOP_FA) that I am investigating is not. Only when executed manually, as shown above, it works - with 3h runtime.There is no Backgroundjob created at 9 PM for that IAL Queue config: System Parameters: EDIT:I have recalculated “Next Update Begins” Time - since it missed the last scheduled run, this one got empty.

2 years ago

Replies posted by flestephs

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded