Hello
I do not know why, but I have a random error when trying to gather data from a linked table using PI Web API's GetData function of Tables: tables/{webId}/data
The linked table is parametrized like this: Linked - SELECT * FROM [dbo].[TestTable] WHERE [Test1] = @Test1 AND [Test2] = @Test2
The call to PI Web API is done like: https://{server}/piwebapi/tables/{tableWebId}/data?parameters[@Test1]=Test%201&parameters[@Test2]=Test%202
I have this error:
{
"Errors": [
"Unable to link to external table: Object reference not set to an instance of an object."
]
}
Has anybody ever seen this? If so, could you please give me a hint on what I can do in order to avoid or fix it? The error message is very misleading! I do not have any idea on what is going wrong!
Many Thanks
