Data file integration (CSV, JSON) in Postman - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the output of this Postman test script when using a CSV data file?

Given this test script in Postman that runs with a CSV data file containing two rows:

pm.test('Check user ID', () => {
    pm.expect(pm.iterationData.get('userId')).to.be.oneOf(['101', '102']);
});

What will be the result after running the collection with this CSV data?

Postman

pm.test('Check user ID', () => {
    pm.expect(pm.iterationData.get('userId')).to.be.oneOf(['101', '102']);
});

A The test throws a runtime error due to invalid syntax.

B The test fails because pm.iterationData.get does not work with CSV files.

C The test passes twice, once for each userId in the CSV file.

D The test passes only once, ignoring the second CSV row.

💡 Hint

Think about how Postman runs tests for each row in a data file.

Postman runs the test script once per data row. Since the CSV has two rows with userId values '101' and '102', and the test checks if the userId is one of these, the test passes twice.

❓ assertion

intermediate

Which assertion correctly verifies a JSON data file value in Postman?

You have a JSON data file with entries like {"username": "alice"}. Which assertion in the test script correctly checks that the username is 'alice' for the current iteration?

A pm.expect(pm.iterationData.username).to.equal('alice');

B pm.expect(pm.iterationData.get('username')).to.eql('alice');

C pm.expect(pm.data.username).to.equal('alice');

D pm.expect(pm.data.get('username')).to.eql('alice');

💡 Hint

Remember the method to get data from the current iteration in Postman.

pm.iterationData.get('key') is the correct way to access data from the current iteration, regardless of CSV or JSON data files.

🔧 Debug

advanced

Why does this Postman test fail when using a JSON data file?

Consider this test script:

pm.test('Check email', () => {
    pm.expect(pm.iterationData.email).to.include('@');
});

When running with a JSON data file containing emails, the test always fails. What is the cause?

Postman

pm.test('Check email', () => {
    pm.expect(pm.iterationData.email).to.include('@');
});

A pm.iterationData is a method, so pm.iterationData.email is undefined causing the test to fail.

B The test syntax is invalid because include() is not a valid assertion method.

C The JSON data file is malformed, so pm.iterationData cannot read email.

D pm.iterationData.email is correct, but the email values do not contain '@'.

💡 Hint

Check how to properly access iteration data in Postman scripts.

pm.iterationData is a method object, not a plain object. You must use pm.iterationData.get('email') to access the value. Using pm.iterationData.email returns undefined, causing the assertion to fail.

❓ framework

advanced

How to configure Postman to run a collection with a JSON data file?

Which step correctly describes how to run a Postman collection using a JSON data file?

A In the Collection Runner, select the collection, click 'Select File', choose the JSON file, then click 'Run'.

B Import the JSON file as a new collection, then run it directly without selecting a data file.

C Attach the JSON file in the request body and run the collection normally.

D Convert the JSON file to CSV first, then use the Collection Runner to select the CSV file.

💡 Hint

Think about how Postman uses data files in the Collection Runner.

Postman Collection Runner allows you to select a data file (CSV or JSON) to run the collection multiple times with different data. You select the file in the runner before starting.

🧠 Conceptual

expert

What is the main difference in handling CSV vs JSON data files in Postman tests?

When using CSV and JSON data files in Postman Collection Runner, what is the key difference in how data is accessed in test scripts?

A CSV data must be converted to JSON before use; JSON data can be used directly.

B CSV data requires pm.iterationData.get('key'), but JSON data uses pm.data.key directly.

C CSV data is accessed by index, JSON data by key name in pm.iterationData.

D There is no difference; both use pm.iterationData.get('key') to access values.

💡 Hint

Consider the Postman API for accessing iteration data regardless of file type.

Postman abstracts data file format differences. Both CSV and JSON data files are accessed in test scripts using pm.iterationData.get('key').