Replace JSON content in a .txt file with just a String (WSO2 Integrator)
0
I have a .txt file that looks like this:
"name":"John"
I need to replace the JSON with just the "John" part so the .txt file contains nothing but
John
inside it (just a regular text, no quotes around it).
I am using the WSO2 Integrator. I have looked into the PayloadFactory and the Smooks mediators but they only give back either JSON or xml. I am also looking at the Enrich mediator but no matter how I twist it, it doesnt affect the text file at all.
json xml wso2 wso2esb transformation
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
add a comment |
0
I have a .txt file that looks like this:
"name":"John"
I need to replace the JSON with just the "John" part so the .txt file contains nothing but
John
inside it (just a regular text, no quotes around it).
I am using the WSO2 Integrator. I have looked into the PayloadFactory and the Smooks mediators but they only give back either JSON or xml. I am also looking at the Enrich mediator but no matter how I twist it, it doesnt affect the text file at all.
json xml wso2 wso2esb transformation
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
If you know that the input is"name":"John"then you don't need to do any processing, just output "John". The reason you need a program is presumably that the input might be something different, like"name":"Jane". But then the question becomes, what is the possible range of inputs that the program might encounter? And what is the program required to do if the input is outside this range?
– Michael Kay
Nov 15 '18 at 21:07
Once you read the file try using the expression json-eval($.name).
– amg_amit
Nov 16 '18 at 10:01
@amg_amit I did try with json-eval($.name) and it does replace the content of the file with "John"... the problem is - I don't need the quotes around the name.
– ZenOctober
Nov 17 '18 at 15:29
If you do not require the quote then after you fetch the data using the expression try using the substring before and after "" to remove the quotes, if this is not feasible then try using payload mediator
– amg_amit
Nov 19 '18 at 5:59
add a comment |
0
0
0
I have a .txt file that looks like this:
"name":"John"
I need to replace the JSON with just the "John" part so the .txt file contains nothing but
John
inside it (just a regular text, no quotes around it).
I am using the WSO2 Integrator. I have looked into the PayloadFactory and the Smooks mediators but they only give back either JSON or xml. I am also looking at the Enrich mediator but no matter how I twist it, it doesnt affect the text file at all.
json xml wso2 wso2esb transformation
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
I have a .txt file that looks like this:
"name":"John"
I need to replace the JSON with just the "John" part so the .txt file contains nothing but
John
inside it (just a regular text, no quotes around it).
I am using the WSO2 Integrator. I have looked into the PayloadFactory and the Smooks mediators but they only give back either JSON or xml. I am also looking at the Enrich mediator but no matter how I twist it, it doesnt affect the text file at all.
json xml wso2 wso2esb transformation
json xml wso2 wso2esb transformation
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
asked Nov 15 '18 at 19:13
ZenOctoberZenOctober
1015
1015
If you know that the input is"name":"John"then you don't need to do any processing, just output "John". The reason you need a program is presumably that the input might be something different, like"name":"Jane". But then the question becomes, what is the possible range of inputs that the program might encounter? And what is the program required to do if the input is outside this range?
– Michael Kay
Nov 15 '18 at 21:07
Once you read the file try using the expression json-eval($.name).
– amg_amit
Nov 16 '18 at 10:01
@amg_amit I did try with json-eval($.name) and it does replace the content of the file with "John"... the problem is - I don't need the quotes around the name.
– ZenOctober
Nov 17 '18 at 15:29
If you do not require the quote then after you fetch the data using the expression try using the substring before and after "" to remove the quotes, if this is not feasible then try using payload mediator
– amg_amit
Nov 19 '18 at 5:59
add a comment |
If you know that the input is"name":"John"then you don't need to do any processing, just output "John". The reason you need a program is presumably that the input might be something different, like"name":"Jane". But then the question becomes, what is the possible range of inputs that the program might encounter? And what is the program required to do if the input is outside this range?
– Michael Kay
Nov 15 '18 at 21:07
Once you read the file try using the expression json-eval($.name).
– amg_amit
Nov 16 '18 at 10:01
@amg_amit I did try with json-eval($.name) and it does replace the content of the file with "John"... the problem is - I don't need the quotes around the name.
– ZenOctober
Nov 17 '18 at 15:29
If you do not require the quote then after you fetch the data using the expression try using the substring before and after "" to remove the quotes, if this is not feasible then try using payload mediator
– amg_amit
Nov 19 '18 at 5:59
If you know that the input is
"name":"John" then you don't need to do any processing, just output "John". The reason you need a program is presumably that the input might be something different, like "name":"Jane". But then the question becomes, what is the possible range of inputs that the program might encounter? And what is the program required to do if the input is outside this range?– Michael Kay
Nov 15 '18 at 21:07
If you know that the input is
"name":"John" then you don't need to do any processing, just output "John". The reason you need a program is presumably that the input might be something different, like "name":"Jane". But then the question becomes, what is the possible range of inputs that the program might encounter? And what is the program required to do if the input is outside this range?– Michael Kay
Nov 15 '18 at 21:07
Once you read the file try using the expression json-eval($.name).
– amg_amit
Nov 16 '18 at 10:01
Once you read the file try using the expression json-eval($.name).
– amg_amit
Nov 16 '18 at 10:01
@amg_amit I did try with json-eval($.name) and it does replace the content of the file with "John"... the problem is - I don't need the quotes around the name.
– ZenOctober
Nov 17 '18 at 15:29
@amg_amit I did try with json-eval($.name) and it does replace the content of the file with "John"... the problem is - I don't need the quotes around the name.
– ZenOctober
Nov 17 '18 at 15:29
If you do not require the quote then after you fetch the data using the expression try using the substring before and after "" to remove the quotes, if this is not feasible then try using payload mediator
– amg_amit
Nov 19 '18 at 5:59
If you do not require the quote then after you fetch the data using the expression try using the substring before and after "" to remove the quotes, if this is not feasible then try using payload mediator
– amg_amit
Nov 19 '18 at 5:59
add a comment |
1 Answer
1
active
oldest
votes
0
Try this;
<property name="name" expression="json-eval($.name)" scope="default" type="STRING"/>
<payloadFactory media-type="xml">
<format>
<ms11:text xmlns:ms11="http://ws.apache.org/commons/ns/payload">$1</ms11:text>
</format>
<args>
<arg evaluator="xml" expression="$ctx:name"/>
</args>
</payloadFactory>
<property name="messageType" value="text/plain" scope="axis2"/>
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
Thank you, Erandika! This did the job
– ZenOctober
Nov 19 '18 at 18:48
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53326450%2freplace-json-content-in-a-txt-file-with-just-a-string-wso2-integrator%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Try this;
<property name="name" expression="json-eval($.name)" scope="default" type="STRING"/>
<payloadFactory media-type="xml">
<format>
<ms11:text xmlns:ms11="http://ws.apache.org/commons/ns/payload">$1</ms11:text>
</format>
<args>
<arg evaluator="xml" expression="$ctx:name"/>
</args>
</payloadFactory>
<property name="messageType" value="text/plain" scope="axis2"/>
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
Thank you, Erandika! This did the job
– ZenOctober
Nov 19 '18 at 18:48
add a comment |
0
Try this;
<property name="name" expression="json-eval($.name)" scope="default" type="STRING"/>
<payloadFactory media-type="xml">
<format>
<ms11:text xmlns:ms11="http://ws.apache.org/commons/ns/payload">$1</ms11:text>
</format>
<args>
<arg evaluator="xml" expression="$ctx:name"/>
</args>
</payloadFactory>
<property name="messageType" value="text/plain" scope="axis2"/>
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
Thank you, Erandika! This did the job
– ZenOctober
Nov 19 '18 at 18:48
add a comment |
0
0
0
Try this;
<property name="name" expression="json-eval($.name)" scope="default" type="STRING"/>
<payloadFactory media-type="xml">
<format>
<ms11:text xmlns:ms11="http://ws.apache.org/commons/ns/payload">$1</ms11:text>
</format>
<args>
<arg evaluator="xml" expression="$ctx:name"/>
</args>
</payloadFactory>
<property name="messageType" value="text/plain" scope="axis2"/>
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
Try this;
<property name="name" expression="json-eval($.name)" scope="default" type="STRING"/>
<payloadFactory media-type="xml">
<format>
<ms11:text xmlns:ms11="http://ws.apache.org/commons/ns/payload">$1</ms11:text>
</format>
<args>
<arg evaluator="xml" expression="$ctx:name"/>
</args>
</payloadFactory>
<property name="messageType" value="text/plain" scope="axis2"/>
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
answered Nov 18 '18 at 13:59
Erandika HarshaniErandika Harshani
1245
1245
Thank you, Erandika! This did the job
– ZenOctober
Nov 19 '18 at 18:48
add a comment |
Thank you, Erandika! This did the job
– ZenOctober
Nov 19 '18 at 18:48
Thank you, Erandika! This did the job
– ZenOctober
Nov 19 '18 at 18:48
Thank you, Erandika! This did the job
– ZenOctober
Nov 19 '18 at 18:48
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53326450%2freplace-json-content-in-a-txt-file-with-just-a-string-wso2-integrator%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If you know that the input is
"name":"John"then you don't need to do any processing, just output "John". The reason you need a program is presumably that the input might be something different, like"name":"Jane". But then the question becomes, what is the possible range of inputs that the program might encounter? And what is the program required to do if the input is outside this range?– Michael Kay
Nov 15 '18 at 21:07
Once you read the file try using the expression json-eval($.name).
– amg_amit
Nov 16 '18 at 10:01
@amg_amit I did try with json-eval($.name) and it does replace the content of the file with "John"... the problem is - I don't need the quotes around the name.
– ZenOctober
Nov 17 '18 at 15:29
If you do not require the quote then after you fetch the data using the expression try using the substring before and after "" to remove the quotes, if this is not feasible then try using payload mediator
– amg_amit
Nov 19 '18 at 5:59