Searching / Matching Data in a flow

Questions
1

Quick question.

Lets say i have a spreadsheet with a list of stuff in it, for example software/vendor names.

Then I have a workflow that pulls back JSON CVE information, and one of the fields mentions the software name or the vendors e.g Google, or Microsoft etc.

Is there a way to using the CVE data, query/grep/mine/search the spreadsheet to find if there is a match, basically a lookup.

E.G
(Dummy fake data)
CVE-2022-1234 = Chrome / Google

Spreadsheet
Cell A | Cell B | Cell C | etc
Vendor | Software | Version | Etc
Google | Chrome | 123 | etc
Microsoft | Edge | 345 | etc

the spreadsheet I’m sure I can get into json format somehow also.

Match Google with Google or Chrome with chrome etc.

and then do this per item in the json list.

if that makes sense?

2

Hey Red,
I am not entirely sure I understand your question. Is your question about working with CVE data? If yes can you post an example of what this would look like. Or is your question about transforming a spreadsheet to json and than match things from here?

3

no the question is taking data from one source and trying to find a match in another source and the best way to do this

4

Ahhhh so you have this string

And you want to find matching rows here

1 Like
6

Yeah basically, not that exact string but you get the idea.

It’s more the technique of how to find a result / match a result between two data sources.

7

You could try using multiple Merge nodes with mode keep key matches. Here is an example workflow to illustrate.

2 Likes
8

hmm, will give it a go, see what it lets me do. cheers