# Transform text a dn convert it back to xml

Hi,

i´m calling an api, getting an xml back, transform it to json and need to do a text manipulation (INSERT → OFFLINE)

Somehow I´m struggling to get it right:

``````joblisting
{
"reference_id": "174251869",
"sender_id": "253207",
"action": "INSERT",
"categorization": {
"workfield": {
"id": "2000000"
},
"sector": [
{
"id": "29000"
},
{
"id": "24000"
},
{
"id": "6000"
}
],
"contracttype": {
"id": "222"
}
}
``````

Could someone push me in the right direction, tried to do it wit a set node but can’t get the expression right.

Hey @Kool_Baudrillard, with which step exactly are you struggling?

Are you trying to insert text into any of the fields of the JSON structure you have posted?

Hi, MutedJam!

Yes, I´m trying to replace “action”: “INSERT”, to “action”: “OFFLINE”,

In this case I don’t think you’d need an expression, plain text should do. Here’s a Set node overwriting the `action` value in your example data structure:

This is the result when executing this example workflow:

Hope this helps!

1 Like

WTF? Sometimes it’s so obvious you can’t see it.

Thx!

1 Like

No worries, glad to hear this works for you