csvMatchingRows

[madgup1111]

Using below in response file

{
"partnerDetails": [{{#each (csvMatchingRows ‘saseID’ ‘partnerID’ (Request.Body 'jsonpath' '$.partnerID') ‘ban’)}}
{
"partnerName": "VERSA",
"mccid": "1-2LGSN5M",
"partnerID": "{{this.partnerID}}",
"accountNumber": "{{this.ban}}",
"orgID": "string"
}{{#unless @last}},{{/unless}} {{/each}}
],
"hasMoreRows": false
}

but seems it is not working

Request:
{"PageSize":"500","partnerName":"VERSA","mccid":null,"partnerID":"TEST-CONCERTO-11-3-3-8498","PageNo":"1","accountNumber":[]}

getting response below on hitting:
{
"partnerDetails": [],
"hasMoreRows": false
}

[tommysitu]

@madgup1111 could you share a sample of your csv data source as well? I might be able to help.

[madgup1111]

@tommysitu reference csv file sample data

ban,partnerID
123101654,TEST-CONCERTO-11-3-3-sa-1
970771363,TEST-CONCERTO-11-3-3-sa-1
200204853,TEST-CONCERTO-11-3-3-sa-5
893927078,TEST-CONCERTO-11-3-3-sa-18
948428391,TEST-CONCERTO-11-3-3-sa-17
120879162,TEST-CONCERTO-11-3-3-sa-16
120879191,TEST-CONCERTO-11-3-3-sa-2
120879218,TEST-CONCERTO-11-3-3-sa-15
120879240,TEST-CONCERTO-11-3-3-sa-14
120879273,TEST-CONCERTO-11-3-3-sa-3
120879318,TEST-CONCERTO-11-3-3-sa-14
120879488,TEST-CONCERTO-11-3-3-sa-13
120879535,TEST-CONCERTO-11-3-3-sa-12
123101509,TEST-CONCERTO-11-3-3-sa-4
123101510,TEST-CONCERTO-11-3-3-sa-11
123101566,TEST-CONCERTO-11-3-3-sa-10
123101585,TEST-CONCERTO-11-3-3-sa-9

[tommysitu]

Thanks @madgup1111 I can see the bug, I'm fixing it now.

[tommysitu]

I've got it working, your simulation file should looks something like this:

{
	"data": {
		"pairs": [
			{
				"request": {
					"path": [
						{
							"matcher": "exact",
							"value": "/"
						}
					],
					"method": [
						{
							"matcher": "exact",
							"value": "POST"
						}
					],
					"destination": [
						{
							"matcher": "exact",
							"value": "jsontest.com"
						}
					],
					"scheme": [
						{
							"matcher": "exact",
							"value": "http"
						}
					],
					"body": [
						{
							"matcher": "json",
							"value": "{\"PageSize\":\"500\",\"partnerName\":\"VERSA\",\"mccid\":null,\"partnerID\":\"TEST-CONCERTO-11-3-3-8498\",\"PageNo\":\"1\",\"accountNumber\":[]}"
						}
					]
				},
				"response": {
					"status": 200,
					"body": "{\"partnerDetails\": [{{#each (csvMatchingRows 'saseID' 'partnerID' (Request.Body 'jsonpath' '$.partnerID'))}}{\"partnerName\": \"VERSA\",\"mccid\": \"1-2LGSN5M\",\"partnerID\": \"{{this.partnerID}}\",\"accountNumber\": \"{{this.ban}}\",\"orgID\": \"string\"}{{#unless @last}},{{/unless}} {{/each}}],\"hasMoreRows\": false}",
					"encodedBody": false,
					"templated": true
				}
			}
		],
		"globalActions": {
			"delays": [],
			"delaysLogNormal": []
		}
	},
	"meta": {
		"schemaVersion": "v5.3",
		"hoverflyVersion": "v1.10.13",
		"timeExported": "2025-05-17T11:53:13+01:00"
	}
}

the templating function should be (csvMatchingRows 'saseID' 'partnerID' (Request.Body 'jsonpath' '$.partnerID')) where

'saseID' - is the name of the templating data source, so you can set it like this using hoverctl: hoverctl templating-data-source set --name saseID --filePath saseID.csv

'partnerID' - is the column you want to filter on

(Request.Body 'jsonpath' '$.partnerID') - is the filter value which would be rendered from the incoming request.

so I only need 3 params instead of 4 as specified in the doc (I will fix it in the same PR later)

[tommysitu]

another issue was that you are using ‘saseID’ rather than 'saseID', noticing the single quote is a different unicode character.

[madgup1111]

You simulation response body is giving below error

An error occurred: data.pairs[125].response open {"partnerDetails": [{{#each (csvMatchingRows 'saseID' 'partnerID' (Request.Body 'jsonpath' '$.partnerID'))}}{"partnerName": "VERSA","mccid": "1-2LGSN5M","partnerID": "{{this.partnerID}}","accountNumber": "{{this.ban}}","orgID": "string"}{{#unless @last}},{{/unless}} {{/each}}],"hasMoreRows": false}: file name too long

[madgup1111]

Also even after updating not getting correct response

[tommysitu]

@madgup1111 please provide all the steps you take to get that error, including the hoverfly/hoverctl command you have run.