Wildcards in element names

[sheetaldolas]

Given following input json

{
"2CBXJC99X":{
         "id":"2CBXJC99X",
         "name":"angular",
         "group":"angular",
         "properties":{
            "hive.password":"‡rehz.agvp.Tyguuk@5g47t402‡",
            "phoenix.password":"‡rehz.agvp.Tyguuk@5g47t402‡",
            "default.password":"‡rehz.agvp.Tyguuk@5g47t402‡",
            "spark2.password":"‡rehz.agvp.Tyguuk@5g47t402‡",
            "spark.password":"‡rehz.agvp.Tyguuk@5g47t402‡",
            "psql.password":"‡rehz.agvp.Tyguuk@5g47t402‡",
            "hive_interactive.password":"‡rehz.agvp.Tyguuk@5g47t402‡"
         }
      }
}

How do we create json path to get all elements ending with password.

Something like $/*/properties/*password and $/*/properties/*password* ? But that does not seem to work. Is it already possible? If yes how? If not, can support for it be added?

[rjv9645]

Hello,

I do not think key filtering with wildcards is currently supported. However if your goal is to get all elements with 'password' in the key, you could do this by retrieving the parent object and filtering that. Example unit test:

@SuppressWarnings({ "unchecked", "rawtypes" })
@Test
public void retrieveWildCard() {	
	String data = "{ \"value\" : {" +
			"\"test.password\" : \"first\"," +
			"\"other.password\" : \"second\"," +
			"\"not.returned\" : \"third\" } }";

	DocumentContext context = JsonPath.parse(data);
	
	String jsonPath = "$.value";
	
	Predicate<Entry> notPassword = (entry) -> !entry.getKey().toString().contains("password");


	Set<Map.Entry<String, String>> results = context.read(jsonPath, Map.class)
			.entrySet();
	
	results.removeIf(notPassword);
	
	System.out.println(results);
	
	assertThat(results.size()).isEqualTo(2);
}

--Cheers

[raman-shrivastava]

I am also facing similar issue, where using jsonpath I need to fetch a json object and field name includes a . in it. Is there any workaround or patch available for this?

[YuAvillachLab]

Hello,

I do not think key filtering with wildcards is currently supported. However if your goal is to get all elements with 'password' in the key, you could do this by retrieving the parent object and filtering that. Example unit test:

@SuppressWarnings({ "unchecked", "rawtypes" })
@Test
public void retrieveWildCard() {	
	String data = "{ \"value\" : {" +
			"\"test.password\" : \"first\"," +
			"\"other.password\" : \"second\"," +
			"\"not.returned\" : \"third\" } }";

	DocumentContext context = JsonPath.parse(data);
	
	String jsonPath = "$.value";
	
	Predicate<Entry> notPassword = (entry) -> !entry.getKey().toString().contains("password");


	Set<Map.Entry<String, String>> results = context.read(jsonPath, Map.class)
			.entrySet();
	
	results.removeIf(notPassword);
	
	System.out.println(results);
	
	assertThat(results.size()).isEqualTo(2);
}

--Cheers

This will work, but then the question is if we need to go over each element, why we need JsonPath?