Difference between QUERY and QUERYV2 while making api

While creating a database API, I noticed that the execution type dropdown has options for Query and Queryv2. What is the difference between these two options?

1 Like

Hi @Anuj_Tiwari when we talk about the difference between QUERY AND QUERYV2 then the main difference is the output response in both the cases.
For example:-
Below is the output of database API with type selected as query:-
{
“TRAINING_API”: {
“records”: [
{
“primary_key”: “”,
“data”: [
{
“TRAINING_QUERY”: {
“status”: “SUCCESS”,
“response”: [
{
“group_id”: null
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
}
]
}
}
]
}
],
“responseHandledBy”: “MOBILE APP”,
“isSuccessRuleValidated”: true
}
}

And below is the output of same database API with type selected as QUERYV2:-

{
“TRAINING_API_SECOND”: {
“records”: [
{
“primary_key”: “”,
“data”: [
{
“status”: “SUCCESS”,
“response”: [
{
“group_id”: null
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
},
{
“group_id”: “RMU_TEST”
}
]
}
]
}
],
“responseHandledBy”: “MOBILE APP”,
“isSuccessRuleValidated”: true
}
}

2 Likes