Sample JSON file

This represents the sample JSON (JavaScript Object Notation) file that ships with the RDBMS software.

{

"OmfEgress": {

"Logging": {

"logLevel": "Information",

"logFileSizeLimitBytes": 34636833,

"logFileCountLimit": 31

},

"DataEndpoints": [

{

"id": "Local PI",

"endpoint": "https://<server-name>/piwebapi/OMF",

"userName": "<user-name>",

"password": "<password>"

},

{

"id": "CDS",

"endpoint": "https://your-endpoint/api/v1/tenants/<tenantId>/namespaces/<namespaceId>/omf",

"clientId": "<Client-Id>",

"clientSecret": "<Client-Secret>"

}

]

},

"System": {

"Logging": {

"logLevel": "Information",

"logFileSizeLimitBytes": 34636833,

"logFileCountLimit": 31

},

"HealthEndpoints": [

{

"id": ""Connect Health Endpoints"",

"endpoint": "https://your-endpoint/api/v1/tenants/<tenantId>/namespaces/<namespaceId>/omf",

"clientId": "<Client-Id>",

"clientSecret": "<Client-Secret>"

}

],

"Components": [

{

"componentId": "OmfEgress",

"componentType": "OmfEgress"

},

{

"componentId": "RDBMS1",

"componentType": "RDBMS"

}

],

"Buffering": {

"bufferLocation": "<../OSIsoft/Adapters/RDBMS/Buffers>",

"maxBufferSizeMB": 1024,

"enablePersistentBuffering": true

},

"General": {

"enableDiagnostics": true,

"metadataLevel": "Medium",

"includeSourceProperties": [

"All"

],

"healthPrefix": null

},

"ClientFailover": {}

},

"RDBMS1": {

"Logging": {

"logLevel": "Information",

"logFileSizeLimitBytes": 34636833,

"logFileCountLimit": 31

},

"DataSource": {

"connectString": "Server=<db-server-name>;Database=<db-name>;User Id=<user-name>;Password=<password>;trustServerCertificate=True",

"maxHistoryEventsPerSecond": 0,

"utc": false,

"dataProvider": "SQLServer",

"streamIdPrefix": "<Stream-prefix>",

"defaultStreamIdPattern": ".{SourceId}.{SelectValue}"

},

"DataFilters": [

{

"id": "DuplicateData",

"absoluteDeadband": 0,

"percentChange": null,

"expirationPeriod": "1:00:00"

}

],

"DataSelection": [

{

"valueColumn": "Temperature",

"dataColumns": null,

"indexColumn": "Timestamp",

"queryId": "Test",

"selectColumn": null,

"selectValue": null,

"scheduleId": "1",

"uom": "°",

"selected": true,

"name": null,

"streamId": ".Test.Temperature.",

"dataFilterId": null

},

{

"valueColumn": "ID",

"dataColumns": null,

"indexColumn": "Timestamp",

"queryId": "Test",

"selectColumn": null,

"selectValue": null,

"scheduleId": "1",

"uom": null,

"selected": true,

"name": null,

"streamId": ".Test.ID.",

"dataFilterId": null

},

{

"valueColumn": "Pressure",

"dataColumns": null,

"indexColumn": "Timestamp",

"queryId": "Test",

"selectColumn": null,

"selectValue": null,

"scheduleId": "1",

"uom": "°C",

"selected": true,

"name": null,

"streamId": ".Test.Pressure.",

"dataFilterId": null

},

{

"valueColumn": "Volume",

"dataColumns": null,

"indexColumn": "Timestamp",

"queryId": "Test",

"selectColumn": null,

"selectValue": null,

"scheduleId": "1",

"uom": "K",

"selected": true,

"name": null,

"streamId": ".Test.Volume.",

"dataFilterId": null

}

],

"Schedules": [

{

"id": "1",

"period": "0:00:05",

"offset": "0:00:00"

}

],

"Queries": [

{

"queryString": "SELECT [ID],[Temperature],[Pressure],[Volume],[Timestamp], '°' UoMDegree, '°C' UoMDegreeCentigrade, 'K' UoMKelvin FROM [dbo].[OscillatingData] WHERE [Timestamp] > ?LST? ORDER BY [Timestamp] ASC",

"queryId": "Test"

}

]

}

}