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. Upgrade .NET version support for AF SDK

    Please add support for .NET Core to the AF SDK. Currently only full .NET Framework is supported.

    146 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    32 comments  ·  PI AF SDK  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you all for your valuable feedback. While we appreciate the interest the community has for this suggestion, we have decided to not pursue this item for now in favor of other high priority work. We realize that this is a popular idea, and we will continue to evaluate its impact for our customers and partners. We will update this idea’s status if we begin to work on this.
    For non-Windows environments, our current suggestion is to use the PI Web API for programmatic PI Server access.

  2. PI Data via MQTT Broker

    Allow external applications to consume PI system data via MQTT.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  3. OSIsoft Python Library for data science

    As a data scientist, I would like to be able to use a fully supported OSIsoft Python library without having to directly interface my Python script with a middleware. This OSIsoft Python library would be able to perform the same operations as PI DataLink, but directly in Python. Having this OSIsoft Python library would be beneficial for me because it would greatly improve the time needed to create data analysis scripts and make it a lot easier to interface with 3rd party Python libraries like Pandas for data analysis.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. Expose analysis error codes in PI Web API

    Currently, it is possible to get the status (Enabled, Disabled) of the analysis via the Analysis controller. However, there is no way to know if the analysis is in error or not. It may be Enabled but not outputting any values due to the errors which are not available in PI Web API.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  5. Have the PI OPC DA Server not rely on cache files (SavedNamespace.xml) for tag changes

    It would be beneficial to some customers to not have to restart the PI OPC DA Server or delete the SavedNamespace.xml in order to keep track of tag changes.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI OPC DA & HDA Servers  ·  Flag idea as inappropriate…  ·  Admin →
  6. Bypass Certificate Prechecks for PI Web API Admin Utility

    Using PI Web API Admin Utility to use a 3rd party certificate, with no access to recovation servers, the Admin Utility will not able to locate this certificate.

    Requesting feature for PI Web API Admin Utility to bypass the certificate checks where the certificate cannot be validated

    Similar request:
    1. Bypass Certificate Prechecks for PI Integrator Upgrade
    2. Allow installer to (optionally) bypass Certificate checks, this feature is only completed for Vision but Vision 2020 do not use PI Web API anymore

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow configuration of PI Web API Stream and Stream Set responses to either always or never include an 'Errors' field

    Currently, when a response to a Stream or Stream Set controller encounters an error, an 'Errors' field will be included in the response, and when no error is encountered the 'Errors' field will be absent in the response. This behavior can impact applications that depend on a defined set and/or number of properties to be included in a response. For such cases it would be beneficial to have the ability to either configure PI Web API, or provide a URL parameter setting (e.g. a "selectedFields" setting), to always, or never, include an 'Errors' field in the response, regardless of whether…

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add Support for TLS 1.3

    I would like to use TLS 1.3 to secure communication for PI Web API since is the latest and most secure transport layer cryptographic protocol.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  9. Drop support for TLS 1.0 and TLS 1.1

    The blog post linked below urges customers to disable TLS 1.0 and TLS 1.1 but also mentions that PI Web API supports them.
    https://pisquare.osisoft.com/s/Blog-Detail/a8r1I000000GvqGQAS/tls-best-practices-for-pi-web-api

    Please drop support for TLS 1.0 and TLS 1.1 from PI Web API to force customers to use a secure configuration.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  10. Make PI Web API responses more descriptive or allow developers to configure their own custom response fields.

    Currently if a PI Web API user attempts an action which is not allowed, the error handling is somewhat generic.
    Stream and Stream Set controller calls might contain an additional information in the response fields, but not always.
    e.g. Trying to create a tag using an existing Tag name results in: 409 with error message “An exception has occurred. Please contact your PI Web API administrator for help in enabling debug mode”
    Better response codes would allow developers to add custom application logic and inform end users what went wrong in their request.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add support for nested SELECT statements in PI SQL (RTQP)

    The current version of PI DAS (RTQP Engine) does not support nested SELECT statements. This is a rather dire oversight, given that the older PI OLEDB Enterprise query engine does support nested SELECT statements.

    A very useful application of nested SELECT could be to centralise some arguments in SQL Views of their own, such as calculated start and end dates of time ranges.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  12. PowerShell Add-PIValue and annotations

    Really need to be able to send annotations to PI Tag Values through PowerShell.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. PI Web API should cache Windows Identities when making multiple requests with Claims Based Authentication

    As a PI Web API client, I would like bearer authentication to be more performant. So that I can write secure, responsive client applications

    BearerAuthenticationProvider should cache WindowsIdentity. Currently ClaimsPrincipal is cached and WindowsIdentity is retrieved for each request from C2WTS.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  14. Provide a PI SQL Commander Lite Standalone Download

    Currently, PI SQL Commander Lite is bundled with PI SQL Client, PI OLEDB Enterprise, and PI ODBC Driver.

    It is a very useful tool for PI OLEDB Provider, which does not bundle it. To use it, another provider needs to be installed to obtain PI SQL Commander Lite indirectly.

    The version of PI SQL Commander Lite that is bundled with each provider is the latest version of PI SQL Commander Lite at the time of the provider's release. This means that the latest versions of each provider could have different versions of PI SQL Commander Lite bundled with them.

    Manageability…

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  15. Writing to AF Table through PI Web API

    Currently PI WebAPI provides only the method UpdateData /Put Tables (https://techsupport.osisoft.com/Documentation/PI-Web-API/help/controllers/table/actions/updatedata.html) to insert data into an AF table and this method requires the entire table data to be sent in the request and it is not currently possible to simply append new rows. It is inconvenient to update the entire table content always as you have GET the current data from the table, add in new content and then use the UpdateData / Put method to save the entire table. As the AF tables get larger, this would cause more network traffic and more error prone. We would…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Web API  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add support for local variables in PI SQL (RTQP)

    The current version of PI DAS (RTQP Engine) does not support local variables. It causes rather clumsy constructs in some instances.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add RTQP PI SQL support for default value of function parameter

    The current version of PI DAS (RTQP Engine) does not support the definition of default values for table-valued function parameters. This is a rather bleak omission, in my view. For example, the following will fail to create the table-valued function:

    CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDataSummaries]
    (
    @StartTime DateTime,
    @EndTime DateTime,
    @TimeStep TimePeriod,
    @TimeType String = 'MostRecentValue'
    )
    AS
    SELECT i.*
    ,s.Value

    FROM MOMS.dim.InstrumentsBase i

    CROSS APPLY [MOMS].[fact].[Instrument Base Template_GetSummaries]
    (
    i.ElementID, --Element ID
    @StartTime, --Start Time
    @EndTime, --End Time
    @TimeStep, --Time Step
    @TimeType --Time Type
    ) s

    It should not. It is most reasonable to wish to provide a default value for…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add RTQP PI SQL support for parameter type cast

    PI DAS (RTQP Engine) 2018 SP3 Patch 1 lacks support for type casting input parameters of a table valued function. For example. this simple example fails to create a table valued function:

    CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDataStringOverload]
    (
    @StartTimeIn String,
    @EndTimeIn String,
    @TimeStepIn String
    )
    AS
    SELECT * FROM MOMS.fact.getInstrumentOperationalData(
    CAST(@StartTimeIn As DateTime)
    ,CAST(@EndTimeIn As DateTime)
    ,CAST(@TimeStepIn As TimePeriod)
    )

    The following example fails in similar fashion:

    CREATE FUNCTION [MOMS].[fact].[getInstrumentOperationalDataStringOverload]
    (
    @StartTimeIn String,
    @EndTimeIn String,
    @TimeStepIn String
    )
    AS
    SELECT * FROM MOMS.fact.getInstrumentOperationalData(
    DateTime(@StartTime)
    DateTime(@EndTime)
    TimePeriod(@TimeStep)
    )

    Error message: The table-valued function definition is not supported.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add support for unit conversion

    Please add a "Canonical UOM Per UOM" or "UOM Per Canonical UOM" column (not necessarily with those exact names) to the UnitOfMeasure table. This column would contain the conversion factor needed to convert between the UOM and the canonical UOM, similar to the "Canonical" column in PI System Explorer when you are viewing a UOM class.

    With this in place, a user can easily convert a value to any unit by first converting from the value's default UOM to the canonical UOM of the value's UOM class, and then convert from the canonical UOM to the desired UOM. This would…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
  20. Get AF Server Name and AF Database Name in PI SQL DAS (RTQP)

    As a PI Applications Developer, I need to be able to retrieve the name of the current AF Server and Current AF Database in the PI SQL DAS (RTQP). This information was available in PI OLEDB Enterprise’s [System].[Connection].[ConnectionProperty] and [System].[Connection].[ConnectionStatus] tables. I would like it to be in PI SQL DAS (RTQP) as well.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI SQL Client  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • 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
TELL US MORE
EVALUATING
PLANNED
IN DEVELOPMENT
COMPLETED
DECLINED