Often we query by a template name to get a transposed list of attribute values between a nominated date range. The hacked OLEDB SQL code is below.

Ideally, I'd like to be able to run this as a WEB API Call. Can you provide a WEB API Example of calling transposed data by Template between a nominated date range and then filtering the records that do not meet criteria? In this example, they're not null.

SELECT eh.Path + eh.Name as Element, ta.[time] as dt, ta.[Tag 1 Name] as Tag1, [Tag 2 Name]as Tag2
FROM '@AFDatabase'.[Asset].[ElementTemplate] et
INNER JOIN '@AFDatabase'.[Asset].[Element] e
ON et.ID = e.ElementTemplateID
INNER JOIN '@AFDatabase'.[Asset].[ElementHierarchy] eh
ON e.ID = eh.ElementID
CROSS APPLY '@AFDatabase'.DataT.[TransposeArchive_Bay]
( eh.ElementID,
DATE(N'@StartTime'), /StartTime/
DATE(N'') /EndTime*/
) ta
WHERE et.Name = N'@TemplateName'
AND eh.Path + eh.Name = '@ElementName'
AND ta.[Tag 1 Name] IS NOT NULL
AND [Tag 2 Name] IS NOT NULL
OPTION (FORCE ORDER, IGNORE ERRORS, EMBED ERRORS)

OSIsoft currently offers OSIsoft Cloud Services and PI Cloud Connect, and it will only continue to expand its offering of cloud-based technologies and programs that integrate with cloud services.
https://www.osisoft.com/Solutions/OSIsoft-Cloud-Services/

Please make a course about these and allow the customer to practice in a Training Cloud Environment. As with any multi-program course, the benefits are that the customer will learn how to use their current cloud setup more effectively and that they will understand parts of the OSIsoft cloud that they don't currently use. The latter will help them see the benefits of the OSIsoft cloud, which translates to more business for OSIsoft.

The creation of such a course will also help assert the idea that OSIsoft's cloud technologies are just as important, to customers and to OSIsoft, as the classic PI system.