AnsweredAssumed Answered

PI DataLink: any smart way to detect errors or no results from calls to DataLink?

Question asked by Roger Palmen on Jan 5, 2015
Latest reply on Jan 6, 2015 by Peter Falk

Hi All,

 

I'm building some reports in Excel (2010) and DataLink (2014). When results are returned, there are many different ways how errors are reported back. "Tag not found", "Attribute not found", "No events found.".

Is there any smart way to detect if a cell has a valid result or not? E.g. how to detect if i have a valid result when retrieving an AF attribute of type String with the value "Attribute not found".

 

When numeric values are expected, a check for IsNumber() helps, but e.g. for strings, this falls apart.

Outcomes