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.

How can we improve PI Developer Technologies for you?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. 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 →
  3. 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 `AFAttribute`s 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.

    6 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. 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.

    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 →
  5. Write annotations on archive data via PI Web API

    My client is interested in writing annotations to Stream (time series) data via the PI Web API. I know it's possible to pull this data via the ?associations=annotations query parameters but the write feature is missing.

    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 →
  6. 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

    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 →

    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]”)

  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.

    5 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. 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.

    5 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 →
  9. Annotate Elements with Web API

    Add functionality to annotate AF Elements using Web API.

    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 →
  10. 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.

    5 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.

  11. Add element reference information to to RTQP tables.

    In OLEDB Enterprise, we could find element references by type.  Currently, this information is not exposed in RTQP.  It would be helpful to be able to identify which type of reference an element is using.  One use case is for PI Admin's to generate reports on element hierarchy to ensure the proper reference is being used by builders of the AF DB.  This is especially helpful in AF DBs where element references are used to build multiple "views" using the same elements and the reference type could be used in conjunction with the new IsPrimaryPath column for reporting.

    4 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 →
  12. af sdk PIPointQuery should allow multiple use of filter name per AND condition, so ranges can be searched

    Currently the PIPointQuery cannot contain a filter condition with same filter name twice per AND condition of the query string.

    PointId:>5 AND PointId:<10.

    This would cause an error.

    Therefore filtering for a certain range is annoying as both result lists then have to be compared for common elements, workaround for the AND in above condition.

    Enhancement:

    Introduce a "BETWEEN" operator for the filter condition.

    Allow multiple use of filter names in the same AND condition.

    4 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 →
  13. Expose Calculation.PercentTrue

    PercentTrue is missing in the WebAPI. Would you consider adding it? For some context, I come from here:

    https://pisquare.osisoft.com/message/115587-re-calculation-percenttrue-is-missing-on-the-webapi

    4 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 →
  14. Automatically update Transpose Function in SQL Commander when referenced Element Template name is updated

    In PI SQL Commander, users can create Transpose Functions that are linked to Element Templates in AF. When the referenced Element Template is renamed in PI System Explorer, the Transpose Function in PI SQL Commander is no longer able to find the Element Template which breaks the Function and underlying Data Table.

    Users are not aware that the Transpose Function or the underlying Transpose Data Table are broken until they attempt to query the Table or Transpose Function.  It would be ideal if the Transpose function could either update this reference automatically or if the function referenced the GUID of…

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add in the Element Hierarchy table information to determine the primary reference of a copied reference element

    When an element is copied as reference (parent-child) elsewhere in the tree it then has multiple parents. One of it is the primary parent. This information needs to be added to the hierarchy tables.

    4 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 →
  16. Improve AF Search PI AF SDK with ORed option

    PI AF SDK - Search Query Syntax - Filters

    Allow results to be ORed. Currently Results can only be ANDed.

    4 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 →

    This is planned for the 2018 R2 release for AF based searches. Note that while the user interface in PSE will allow OR clauses to be typed in, there will not yet be a user interface in 2018 R2 to help you build OR clauses.

  17. Import-AFXml (PowerShell) should have ContinueOnError option

    Both AFImport.exe and ImportXml (AFSDK) have options to continue on error (like is something is checked out or if there is a duplicate element name). For some reason the PowerShell version doesn't. This should be added.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow Creation of Acknowledgeable Event Frames

    The PI Web API exposes a "CanBeAcknowledged" property when reading Event Frames. However, this property is read-only: it cannot be supplied when creating a new Event Frame or updating an existing Event Frame. I would like the ability to include this parameter when creating an Event Frame.

    3 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 →
  19. Support DST Transition on Second Granularity in PI SDK

    A user tries to retrieve date with timestamp 03-Nov-2018 23:59:59 (1 second before Daylight Saving Time beginning) in PI SMT, but the returned event has a timestamp of 04-Nov-2018 00:59:59. This is because PISDK timezone design is such that it can only transition DST on minute granularity, and the Windows TZ info for Brazil says the transition is at 23:59:59 so PISDK truncates the seconds for the transition rule.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. Add support for AFElement Versions

    Add support for AFElement versions to PI Web API.
    1. Create a new Element Version by defining the effective date and an optional version comment. 2. Add Get and Find methods which support querying AFElements by setting a QueryDate.
    See also https://pisquare.osisoft.com/message/122510-re-how-to-create-a-new-af-element-version-with-pi-web-api and https://pisquare.osisoft.com/message/59027

    3 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 →
  • 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
COMPLETED