How to store a JSON in a variable and use it in the request body?

aakashjain8693 · July 29, 2020, 10:33am

@singhsivcan @cdxcz Similarly I have one requirement, would like to understand who I move ahead with Postman.
1.Select the GET Method.
2. Enter the End point http://dummy.restapiexample.com/api/v1/employees URL.
3. Click on send button and get the response.
4. Observe the response.
5. Verify the response body through test script and data driven approach(.csv file)

Who I can verify those data through script, Yes I know one by one I can verify it.
but wanted to make script more generic.
Like put some data into variable, Put same variable and values into .csv file, run the collection run and verify the response.

singhsivcan · July 30, 2020, 9:45pm

@aakashjain8693 You cannot read a CSV file from the test script unfortunately within the Postman app.
You might need to use newman to achieve something like this which is our CLI tool and also can be integrated in node.

I am sure @danny-dainton has some ideas around a solution for this kind of problem.

aakashjain8693 · July 31, 2020, 5:43am

@singhsivcan Thanks for the response, Lets wait for @danny-dainton .

gpub1 · August 10, 2020, 6:29pm

Hi @singhsivcan,

I am unable to work with variable, Variable showing null when used {{temp_token}}

var tempvar = console.log(pm.response.json()["temp token"]); 

temp_token = JSON.stringify(tempvar); 

pm.environment.set("temp_token", temp_token);

@danny-dainton your help would be great

danny-dainton · August 10, 2020, 6:48pm

Hey @gpub1

You might to also need show the response body and how you’re using that variable in the app.

It’s difficult to know what you’re seeing with just the script you’re using to extract the value

gpub1 · August 10, 2020, 6:52pm

yes, kind a new guy on postman…

{
    "temp token": "45351467"
}

This is the response body

danny-dainton · August 10, 2020, 7:09pm

Your response body looks quite basic, don’t see many keys with spaces but that reference should work.

Before running, ensure that you have created and selected an environment file.

let tempVar = pm.response.json()["temp token"]; 

pm.environment.set("temp_token", tempVar);

Add that to the Tests script of the request, the tempVar should then be available for you to use.

SabriH · August 10, 2020, 7:15pm

I believe the behaviour you’re observing is explained here: javascript - Why does console.log say undefined, and then the correct value? - Stack Overflow

gsing · August 10, 2020, 10:22pm

Thanks Danny… Its working now… and skipped this line temp_token = JSON.stringify(tempvar);

danny-dainton · August 10, 2020, 10:25pm

Wasn’t really sure why you even had it in there

Glad you got it working.

aakashjain8693 · August 12, 2020, 12:31pm

Any update @danny-dainton, how I can achieve with Nested array or objects?

aakashjain8693 · August 12, 2020, 1:36pm

@allenheltondev looped you to find out the best result for us.

allenheltondev · August 12, 2020, 2:59pm

Since we seem to be hijacking the thread, it might be better to start a new post with your screenshots and use case stated again.

I think we’ll get better traction that way.

aakashjain8693 · August 12, 2020, 3:15pm

@allenheltondev WIll do, Will give all required details.

smaddirala9571 · September 25, 2020, 7:49pm

What if I have a payload like this set in the globals file:
[{“x”:“abc”,“y”:“efg”,“z”:“hij”}]

But let’s say I want to only access “y” value inside a JSON RAW Body?
Is that possible? I looked at solutions to escape the “” but I’m struggling.

allenheltondev · September 28, 2020, 11:37am

In this case, I would use a prerequest script to scope down the variable you want.

const globalValues = JSON.parse(pm.globals.get('myPayload'));
pm.variables.set('body', globalValues.y);

In the body of your request, you can then reference this value simply by adding in {{body}}

mschuijer · February 4, 2021, 6:29pm

Hi @singhsivcan or other enthusiasts,

I’ve been reading up for the past 3 days and trying out all sorts of suggestions and pieces of code shared here but can’t seem to get things to work as I want. The last I tried was @Sandokhan 's example of “cities”.

I would appreciate anyone’s feedback here.

I am requesting the azure devops service to get a list of projects in our organization and want to re-use the project names in the response in a next request where I need the names to get a another list of what really want to have.

Example response output:

{
    "count": 123,
    "value": [
        {
            "id": "11erui332-1323-4ed3-23r123d4",
            "name": "PROJECT-NAME",
            "url": "https://dev.azure.com/myorg/_apis/projects/id-of-project",
            "state": "wellFormed",
            "revision": 321,
            "visibility": "private",
            "lastUpdateTime": "2020-05-19T14:04:12.69Z"
        },

The “name” value is what I am after. I would like to get all the names and use them in the next request, inserted in the {{project}} variable:

https://dev.azure.com/{{organization}}/{{project}}/_apis/distributedtask/queues?api-version=6.0

pm.collectionVariables.set() and pm.collectionVariables.get() seem the way to go, but I’m missing something I’m sure.

If there’s an example out there I’ve missed let me know please.

Thanks a lot for any pointers, I’m totally new at this. I did manage to get out nice lists and formatted them in tabular output with the visualization, very nice.

singhsivcan · February 7, 2021, 12:42pm

Hey @mschuijer, since I can see that you’ve an array of value in the response, and you only want the first name for your next request?

I think what you want is the following test script (make sure it’s NOT put under the pre-request script):

let projectName = _.get(pm.response.json(), 'value.0.name');

pm.collectionVariables.set('project', projectName);

Now when you run the next request then it should have the correct project name resolved from the collection variable.

mschuijer · February 8, 2021, 9:23am

Thank you for the response.
I actually want to save all the (135) project names and use each one in the next request:
https://dev.azure.com/{{organization}}/{{project}}/_apis/distributedtask/queues?api-version=6.0-preview.1

I don’t know if that’s possible though? The request has only a place for one {{project}} (name) and I wouldn’t know how this would be able to create on output result for all project names.

Thanks again

sonujain · April 16, 2021, 12:58pm

Hi Sivcan, Experts,

I have been trying to develop a piece of code to store the post request output(in json format) in an array and compare the array output with a value to see if it matches my condition.

Requirement:
POST request on https://frxxxxxxxxxxxxxxxxxxxs.cxxxxxxxCOxxxxxxxxxNG
Bearer Token

parse the answer

{
“CE:get_version”: {
“return_code”: 0,
“message”: “DONE”,
“elapse”: 78
},
“CE:get_status”: {
“return_code”: 0,
“message”: “DONE”,
“elapse”: 390
}
}
check that all “return_code” entries are set to 0.
Beware that the number of entries is dynamic and can vary in time, do not assume a fixed content (e.g below answer shows two entries CE:get_version and CE:get_status, but the project will incrementally add some with new names over time without altering the monitoring scenario).

In case any of the return_code is != 0, trigger an error message that includes the full json answer.

Could you please suggest on this. Thanks in advance.