How to extract a specific value from a Request Body in POSTMAN and save in a variable

Ask the Experts and Postman Tips
1

Is there any way to get a specific value ( type="Bank_Application_LOAN_JP_Answer" ) from the Request body and save in a variable in postman?

Request Body

query_xml: "<ROWDATA type="Bank_Application_LOAN_JP">
<ReqID><![CDATA[A-13546]]></ReqID>
<AppNumber><![CDATA[RL048-00/21]]></AppNumber>
<DateTime><![CDATA[01/03/2010 14:57:42]]></DateTime>
<SID><![CDATA[0lebl74v2tr5nnuojvihjma0s0]]></SID>
<ReportType><![CDATA[01]]></ReportType>
<Participient ID="1110">
<KindBorrower>2</KindBorrower>
<TaxID>00000019</TaxID>
<FirmName>[CDATA[Ő“Ô˛Ô¸]]</FirmName>
<RequestTarget>1</RequestTarget>
<UsageRange>1</UsageRange>
</Participient>
</ROWDATA>"

I’ve been using this

let rowdataType = xml2Json(pm.request.body.raw);
pm.environment.set('rowdataType', rowdataType.type);
2

@harutharut,

Similar post is discussed in this thread. In the query of the post the user mentioned a way to your question.

You can use $, something like

console.log(jsonObject['ROWDATA'].$['type']);

It’s a guess based on the response you have provided. Please tweak it based on your request, also try exploring cheerio. Let us know if there’s still an issue to get the value :slightly_smiling_face:

3

Hi @bpricilla , thank you for your answer.
I have tried but the problem is actual. I can not to get the mentioned value from request body.

4

Hello @harutharut,

Okay I get that, it should also work the same way as response. You cannot directly access the object using .type as in JSON.

How do you parse the response here? It’s the same. Just assign it to a different variable than responseBody.

Please try this:

console.log(pm.request.body.raw);
const request = xml2Json(pm.request.body.raw);
var rowdataType = request['ROWDATA'].$['type']
pm.environment.set('rowdataType', rowdataType);

I am throwing this path based on the request body you have mentioned. Please tweak based on your path :slightly_smiling_face:

Else I would need the complete request :blush:

5

maybe I should write pre-request script for getting that value? :slight_smile:

6

let me show you the result.

Screenshot_8
Screenshot_81420Ă—962 110 KB

Screenshot_9
Screenshot_91919Ă—352 12 KB

7

@harutharut Are you using that variable “rowdataType” in the same request body as input/parameter?

If so, then you are right, it should go in pre-request script section :blush:

console.log(pm.request.body.raw);
const requestBody = xml2Json(pm.request.body.raw);
var rowdataType = requestBody['ROWDATA'].$['type']
pm.environment.set('rowdataType', rowdataType);

I have update similar example in one of public workspace collection.

8

Hi @bpricilla , how are you?)

Is strange, but again no result.
I sent request and set pre-request script, but again get error

undefined
TypeError: Cannot read property 'ROWDATA' of undefined
1 Like
9

@harutharut , I am good thank you :blush: Hope you are safe too!!

I am sorry, I can’t assume things here, shall we connect please?

Drop me a message in LinkedIn.

10

ok, I have sent you connection request in Linkedin.

1 Like
11

Based on our discussion your request type is not raw, it is “x-www-form-urlencoded”.

so try this snippet,

console.log(pm.request.body.urlencoded);

Similar to this topic.

You can refer this link for more details.

@harutharut It’s all the same details we discussed yesterday, sharing it here so that it might be useful for someone in future :blush:

Please let me know if there’s still any issue.

12

Hi @bpricilla , thank you for your reply.
Yes, my request type is “x-www-form-urlencoded”.
At this moment, I have done a filter on all the parameters to show only ones that don’t have “disabled: true”
So I have an object and want to have access to the type. Could you help me to find shortest way? :slight_smile:

Screenshot_10
Screenshot_10787Ă—759 62.4 KB

13

Hi,
I found the solution and want to share here, maybe it can be useful for someone)
In my case I had several “x-www-form-urlencoded” key-values(rows). This snippet

const requestBody = xml2Json(pm.request.body.urlencoded);

can’t parse request body, and I had to filter before parsing. Let me show that part below

var params = pm.request.body.urlencoded.filter(function (param) {
    return param.disabled !== true;
});

const requestBody = xml2Json(params[0].value);
//console.log(requestBody['ROWDATA'].$['type']);
var rowdataType = requestBody['ROWDATA'].$['type']
pm.environment.set('rowdataType', rowdataType);
1 Like
14

Thanks for sharing the working snippet @harutharut :clap:

1 Like