Extract Entire array object from json body

Question

Need to extract entire database_schema_detail object from the below json body for postman.Any suggestion?

Json Body

    "created_operator": "0",
    "database": "postgres",
    "database_schema_detail": {
      "accounts": [
        "employer_id",
        "id",
        "role_id"
      ],
      "awsdms_ddl_audit": [
        "c_ddlqry",
        "c_key",
        "c_name",
        "c_oid",
        "c_schema",
        "c_tag",
        "c_time",
        "c_txn",
        "c_user"
      ],
      "new_accounts": [
        "employer_id",
        "id",
        "role_id"
      ]
    },
    "dms_endpoint_id": "test0700362021-10-07t13-19-36-331734",
    "engine": "postgresql",
    "engine_display_name": "PostgreSQL",

Tushar Shahi · Accepted Answer · 2021-10-12 09:56:27Z

1

Parse the JSON and access the property:

let responseBody = JSON.parse(body);
console.log(responseBody.database_schema_detail);

answered Oct 12, 2021 at 9:56

Tushar Shahi

21.6k2 gold badges25 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Julian Nadar IN Over a year ago

Thanks Tushar Shahi for your response..could you help to extract the entire elements of database_schema_detail , my objective is to store the entire o/p for database_schema_detail in a variable so that i can pass it as a parameter to the request body. My Code: pm.test('Validate Schema',function(){ var jsonData=pm.response.json(); pm.environment.set('dbSchemaDetails',jsonData.data.database_schema_detail); console.log(jsonData.data.database_schema_detail); }) Here i am able to log the output ,but unable to store it into "dbSchemaDetails" Appreciate your help..

Julian Nadar IN Over a year ago

Hi Tushar, Was able to solve the issue using JSON.stringify...Thanks for the assist

Collectives™ on Stack Overflow

Extract Entire array object from json body

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related