Now i need to put this coded username and password somewhere in the URL and i dont know where exactly and support wont help me with XML issues...
Only this text is in Pinnacle´s API FAQ
"
Authentication
Always use HTTPS to access the API.
API use HTTP Basic access authentication. You need to send HTTP Authorization header for all API commands . The Authorization header is constructed as follows:
1. Username and password are combined into a UTF-8 string "clientidassword"
2. The resulting string literal is then encoded using Base64
3. "Basic " is then put before the encoded string.
For example, if the client id is 'Aladdin' and password is 'open sesame' then the header is formed as
follows:
Authorization: Basic QWxhZGRpbjpvcGVuIHNlc2FtZQ==
"
So how do i input my username and password into the URL ...
Sorry I don't have a full answer but a quick google check looks like you need to write some VBA code. The issue is that you need to set the authentication details in the http request header - they can't be passed as URL parameters.