Writing a CSV is kicking my butt

Working on a data logging flow, and I am gathering a list of tags through OPC UA.

I receive the tags in what I believe is a JSON object (pictured below):

I then do a bunch of checking and flow control, and if all conditions are met I attempt to convert to CSV, and write that to a server location.

I am able to write the file, but what I'm finding is that the tag values aren't included, and instead its just writing a bunch of commas. (see examples below):


Expecting that I need to change the format of the JSON object to something that will work, but not sure how.

have also attached a shot of what the flow looks like:

Thanks in advance

The object key names in the first image don't match the column names in the second image, so it's difficult to understand what is going between the first image and the second image.

Your screenshot of the flow doesn't help since the configuration of the individual nodes isn't supplied, for example, what configuration are you using for your CSV node?

I would suggest - if this is still an issue - to include a copy of your flows.json. See this article for how to do that.

1 Like

That was the ticket, thanks for your help!

I was trying to make my column names a little more helpful since the tag names are not so descriptive and therein lies the problem.

I changed the column names to match, and now everything works as expected.

1 Like

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.