Context key reorganize

[Antanas]

Hi!

I want to be able to manipulate context keys by selecting the keys I want, and moving them to upper level. E.g.: Assuming I have the following in the context:

I want to have a new context key with only Name and HairColor:

GetFields transformer seems to have similar functionality, however I cannot tell it to get subkeys, e.g. Appearance.Head.HairColor.

Any ideas?

Thanks,

Antanas

[michaelsysec242]

I believe you need to add more context to what you intend by "selecting the keys I want and moving them to the upper level". Why not just created a new context Upper-Level key? You can try running !Print  with this value => ${ParentKey.[].appearance.head}, it should grab all the values you want. Then use !Set or !Setmultiplevalues depending on what works for you. 

Let me know what works for you. 

[chrking · Accepted solution]

A jmespath transformer can do this.

You can test your jmespath expression in the war room like this:

Then use it as a transformer:

And finally check the results in the context:

Also... John should maybe get his red eyes looked at, I'm not a doctor but that doesn't seem normal 🤣

[Antanas]

Hi @chrking  , this worked like a charm! Thanks a lot.

This was just a mock data, not to worry about someones red eyes, all are safe and healthy 🙂

[Antanas]

Hi @michaelsysec242 ,

I think the problem with your suggested approach is that i can't output multiple keys in a singe query, therefore i wouldn't be able to properly set them into one key.

Anyways, the other suggestion was to use jmespath as a transformer, and that worked quite well.

Thanks!