PI Developer Technologies

Welcome to the PI Developer Technologies feedback page!  

This forum covers the PI AF SDK, PI Web API, PI OPC DA and HDA Servers, and the PI SQL family. We created this forum to hear your ideas, feature suggestions and feedback. Please suggest your most important features and design change ideas on this site, and vote for your favorite ideas.

Please note that your ideas and comments posted here are visible to all other users.

  • For bugs, please open a case with OSIsoft Tech Support through myOSIsoft Customer Portal  (https://my.osisoft.com) instead of sharing them on this site.
  • For documentation feedback and bugs, please report to documentation@osisoft.com instead of sharing them on this site.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Be able to use RTQP to access PI Points and Config strings (DA Directly)

    Be able to use RTQP to access PI Points and Config strings (DA Directly)
    Use case:
    create a dashboard that lets me know the amount of bad data (tags) mapped to our AF.

    (eg. “Bad Input”, “Calc Failed”, etc)

    Our system has numerous tags and it is impossible to monitor them one by one.

    The RTQP engine has allowed us to query massive amount of AF Attributes to get their current values easily.

    Some AF attributes have been excluded in our system. For that case, we are not interested whether or not the values are bad.

    Hence I would like…

    9 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  2. AF SDK and Web API on Linux OS'es

    With Microsoft supporting .NET Core on Linux operating systems such as RHEL, SLES Ubuntu, CentOS, and Debian.
    https://docs.microsoft.com/en-us/dotnet/core/about
    https://docs.microsoft.com/en-us/dotnet/core/linux-prerequisites?tabs=netcore2x

    They are even supporting SQL Server on Linux OS'es.

    I don't know the dependencies of the AF SDK nor the Web API, but if they can use .NET Core; it would be nice to have the AF SDK and Web API available for Linux based OS'es.

    9 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  3. Tag Creation

    As a developer of custom applications that use the PI  AF SDK, I'd like to be able to easily determine if an attribute based of an attribute template is configured for tag creation. Currently the AF Attribute Template class does not have this property. The current work around is to look at the configuration string which is less efficient.

    9 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  4. Offer AF SDK as a Nuget package

    To help with quicker deployment, having AF SDK as a nuget package would speed up development and lower barrier to developing against a PI System.

    9 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  5. PI SQL Client to make use of the RecordedValue method and Retrieval Modes for the GetValue transposed function

    When making use of the GetValue transposed function when creating a new Template specific Data Model, we can see that under the hood it makes us of the AF SDK call AFData.InterpolatedValue method to capture the data at a specified timestamp provided in the transposed function. This method does make use of any Retrieval Modes.

    It would be good for this GetValue transposed function to make use under the hood of the AF SDK call AFData.RecordedValue method instead since this method offers the possibility of using Retrieval Modes like "AtOrBefore" which is really useful to capture the last archived value…

    8 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  6. Restrict Access to Web API Endpoint by User

    As a PI Web API administrator, I would like to natively restrict which users can and cannot see particular URLs and controllers on my PI Web API endpoint.

    8 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  7. AdHoc StreamSet actions fail if there is at least one bad WebId

    Currently calling any of the AdHoc StreamSet actions causes the entire call to fail if the request includes at least one bad WebId. It would be better if the response came back successful and only the sub-items with bad WebIds included an error message.

    8 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow configuration of the PI OPC DA Server's ProgID

    The ProgID of the 2015 PI OPC DA Server is OSISoft.OPCDA2.DA.1, while the ProgID of the 2010 PI OPC DA Server is OPC.DA.1.

    Existing client tools that pointed to the 2010 PI OPC DA server will need to be reconfigured to point to the new ProgID after the PI OPC DA server is upgraded to 2015.

    While this is done because of an architecture change between the 2010 and 2015 servers, potentially necessitating changes to be made to the client application, it is still desirable in some cases to point it to the new server without changing the ProgID.

    8 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →
  9. omf endpoint: override type uom in container messages

    OMF 1.2 specification includes an enhancement to allow the use of propertyoverrides keyword in container messages.
    Request is to add this functionality to Web API OMF endpoint specifically for the uom property

    For example:
    1. device configured with uom, OMF application creates a type specifying that uom.
    2 new version of the device changes the uom. OMF application needs to create containers with the new uom, retaining other properties of the type.

    7 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  10. Schedule PI Web API Crawls

    The customer would like the ability to schedule crawls for a specific AF database (it's quite large), so that crawls don't interrupt users who need to access the elements in the PI Vision search during their working hours.

    7 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  11. AF SDK Async Data Methods for multiple AFAttributes

    Expose interfaces for asynchronous data method calls (ex. InterpolatedValues, PlotValues, RecordedValues, Summaries) that:
        1. Take an asynchronous enumerable of AFAttributes as input
        2. Output an asynchronous enumerable of results
        3. Throttle the calls made to PI Data Archive so that it does not overwhelm it

    The use case is to be able to make end-to-end asynchronous data method calls on a set of AFAttributes.

    7 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →
  12. Time Context Value Retrieval

    Example Scenario:

    We want to know the Specific Electricity Consumption (kWh/mt) over a time period (selected by users).

    Specific Electricity Consumption = (Electricity Consumption(kWh)) / (Raw Feed Consumed(mt))

    Where, Electricity Consumption (kWh) and Raw Feed Consumed (mt) are both attributes with PIPoint data reference, using value retrieval method: TimeMethod = Time Range; TimeRangeMethod = Total; EventWeighted

    Then, Specific Electricity Consumption is attribute with Formula data reference, simply: A=Electricity Consumption; B=Raw Feed Consumed;[A/B]

    So, on PI Vision, it can display the specific electricity consumption with the correct values. However, if we query through PI Web API for our own webpage, it…

    7 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  13. Allow PIOLEDB Enterprise to connect directly to a PI Data Archive

    If PI OLEDB Provider is not going to be further developed, allow PI OLEDB Enterprise to connect directly to a PI Data Archive.
    There are times when an SQL type query is needed, but the data structure has not been mapped to an AF server yet.

    7 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
    PLANNED  ·  Ray Verhoeff responded

    We have a new SQL query processing engine under construction. We call it the Real-Time Query Processing Engine, or RTQP Engine. We are targeting improved performance and scalability but we are also improving some of the table designs to make common queries a bit easier. We have talked to many customers about their use cases. It turns out that direct access to PI Data Archive tags is still very important. We also found several hybrid use cases such a summarizing values from a PI tag over the period of an Event Frame, and Kenneth Barber’s excellent example of aligning AF Attributes with PI Point attributes. So, we will be adding direct access to PI tags and data but not in the first release.

  14. Add data reference impersonation for value retrievals

    When retrieving values for attributes, impersonating the user can enable the user of security at the data source level. For example, with a PI Point Data Reference attribute, it could allow the user's authorization to be user at the data archive rather than the PI SQL DAS (RTQP) service account doing the data retrieval.

    6 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  15. Provide programmatic interface to manage OMF applications

    Enable Create,Read, Update, Delete operations for OMF applications via an API so that the process is standardized and efficient/effective as opposed to manual and error prone, especially for larger numbers of apps.

    6 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  16. Expose Values with Duplicate Timestamps in Transpose Function

    https://pisquare.osisoft.com/message/116957-pi-sql-commander-and-ssrs-how-to-retrieve-multiple-values-with-the-same-timstamp

    In the current implementation of the transpose archive in OLEDBEnt, a user is unable to retrieve data that may exist at the same timestamp as  another piece of data. This is because the time column is treated as the primary key of the transpose table. I would like to be able to retrieve all data using the archive transpose function regardless if timestamps are duplicated.

    6 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI OLEDB Enterprise  ·  Flag idea as inappropriate…  ·  Admin →
  17. Support attribute types referencing AF Elements and Attributes

    We use attributes to reference elements and attributes extensively to model context and relationships in our AF models. Is this going to be supported in the future? Kind regards, Gregor

    6 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    This item is under review. Currently considering the following behavior for attributes links:
    Current behavior:
    Error returned: “Unsupported data type: ‘OSIsoft.AF.Asset.AFAttribute’.”
    Similar error for AFElement.

    Change under consideration:
    Value link for Attributes of value type “Attribute” returns the referenced attribute’s GET response (“/attributes/[webid]”)
    Value link for Attributes of value type “Element” returns the referenced element’s GET response (“/elements/[webid]”)

  18. Service to find changes in the PI System

    As a programmer, I want to be able to use the PI Web API to find out about changes in the PI System. This mean Elements, Templates, Attributes, Event Frames and PI Point configuration changes.

    6 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →

    “Finding changes in the PI System” is still being evaluated.

    Correction: Previously this was shown as “planned” and part of Stream Updates. Stream Updates will allow you to retrieve data updates instead of having to retrieve the entire stream.

    The upcoming PI Web API 2018 SP1 release will tell the caller if the stream has changed (e.g., the PI Point data reference was changed to a different PI Point), so that the caller can re-subscribe to the correct stream. It will not provide a mechanism to know what specifically those changes are on the stream, nor on the entire PI System.

  19. Create a utility/script that will output the PI products installed, their versions and the most recent version of the product

    Create a utility/script that will output the PI products installed, their versions and the most recent version of the product on the machine it is run on. This would help with installations and to manage the current software that is installed.

    5 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  20. PI WEB API - Swagger page

    It would be great if as an addition to conventional documentation there was a SWAGGER page with short explanation of methods and parameters (including return types, etc.)

    5 votes
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA/PREVIEW
COMPLETED