Using DataLink or PI Builder, is it possible to retrieve point attributes in bulk by providing only the pointid? I would like to retrieve the point name and ideally other attributes, but I do not see how to do this, in bulk, using only the pointid. Since PI logs often only include the pointid to identify a point with issues, it seems there must be some way to do this.
Thanks.
Chiming in 2-years too late to this thread. But I stumbled across it only because a co-worker asked me a similar question today. I am one who rarely offers a contrary opinion to the respected Steve Kwan, but I can say YES you can use the Point ID in DataLink. I am going to extend Steve's answer with 2 other techniques, though I will admit that Steve's was very simple to use.
I am assuming the reader is moderately experienced with DataLink and/or PI Builder.
First, one thing to try it to lookup the tag names by point id using something like PowerShell. At the OSIsoft Portal (my.osisoft.com) there is a knowledge article titled "Generate Corresponding TagName for PointID Using Powershell". Search for that and follow the instructions. Note: I have not tried this yet myself. And technically, after that, you are then using the tag name in DataLink calls.
The other thing can be used in DataLink and its a nice hack. I absolutely doubt this is a great technique in bulk or will yield high performance. But the hack is that putting a question mark in front of the integer pointid, which transforms it to a text string, can be used in place of the tag name.
In the image below, column D is a lookup of the "tag" Property using column C. And Columns E + F also use column C.
I use simple Excel functions to compose the Hack ID in column C:
=CONCAT("?", $B2)
Hope that helps anyone who needs it.
-Rick Davin, Feb 2023
Chiming in 2-years too late to this thread. But I stumbled across it only because a co-worker asked me a similar question today. I am one who rarely offers a contrary opinion to the respected Steve Kwan, but I can say YES you can use the Point ID in DataLink. I am going to extend Steve's answer with 2 other techniques, though I will admit that Steve's was very simple to use.
I am assuming the reader is moderately experienced with DataLink and/or PI Builder.
First, one thing to try it to lookup the tag names by point id using something like PowerShell. At the OSIsoft Portal (my.osisoft.com) there is a knowledge article titled "Generate Corresponding TagName for PointID Using Powershell". Search for that and follow the instructions. Note: I have not tried this yet myself. And technically, after that, you are then using the tag name in DataLink calls.
The other thing can be used in DataLink and its a nice hack. I absolutely doubt this is a great technique in bulk or will yield high performance. But the hack is that putting a question mark in front of the integer pointid, which transforms it to a text string, can be used in place of the tag name.
In the image below, column D is a lookup of the "tag" Property using column C. And Columns E + F also use column C.
I use simple Excel functions to compose the Hack ID in column C:
=CONCAT("?", $B2)
Hope that helps anyone who needs it.
-Rick Davin, Feb 2023
