URL LOGIN AND PWD

[gdiana]

Hi,

I have a case where I am accessing data for different clients, from the same datasource, but who use different LOGIN's and PWD's.

It appears currently the infinity data source URL setting allows only a single LOGIN and PWD to be used regardless of the client.

So I need to be able to somehow allow several LOGIN and PWD to be defined and to be able to parse a URL parameter that will insert the correct LOGIN and PWD for that client

ie @client = 1 parse LOGIN=BOB&PWD= bob
ie @client = 2 parse LOGIN=MARY&PWD=mary .... etc

Is this currently possible and if not can it be done?

Otherwise, I have to expose each client's USERNAME and PASSWORD

Many thanks

Greg Diana

[yesoreyeram]

You can't use that way. There are couple of other options.

1. Create different datasource for different clients. And then make datasource as a variable.
2. Create username and password as dashboard variables. Like textbox and so you user can enter username and password in the variable textbox
3. Create a lookup table for username and password combination
   But in my opinion none of the above are safe ways. So ideally you have to use one auth credentials for one datasource

[yesoreyeram]

Yea. Glad you solved it yourselves. ( I am not sure you shared the same xml i use or different xml .. previously you shared inline XML and then edited and pointed to some url .. so not sure if i using the correct one)

BTW, i am using the jsonata lib from https://www.npmjs.com/package/jsonata so that must be full support i guess.. but not sure what is missing is library though ..

I agree the editing experience can be improved.. will do few more iteratations.. mostly nowadays i am trying to fix critical bugs and get a stable release. But any kind of feeback is really appreciated

[yesoreyeram]

Multi line string support is not included yet.. haven't found an easy way to fit into existing parser. Hopefully that will get improved over the time.

[gdiana]

The same package is used in NODE-RED but in NR they say you must

In NR for xml2json one has to do the following in the local js.settings files

I am not sure how Grafana works but I presume it must be much the same.

[yesoreyeram]

It seems infinity supports functions as seen here. Not sure what else is missing.

[gdiana]

Ha, ha I suppose that resolves that issue.😂 🤣 😂 👍

[gdiana]

Ok I resolved the issue but maybe did not articulate matters correctly.

I simply created a second Infinity Datasource within Grafana with different logon details. Works perfectly.

What I meant was that the Clients use the same remote application Database from which I was reading data and not the Infinity Datasource.

So one may just use Infinity Client1, Infinity Client 2...... and each may have different LOGON credentials
😀

[yesoreyeram]

If i understand correctly, that's how you are supposed to use it. ( Create different datasource instances and then create datasource variable type on your dashboard )