cannot connect to API LiveChat

[Anonymous]

hi

am trying to connect to the API of LiveChat and am using these steps:

- new sources> Other> Web

- url= https://api.livechatinc.com/v2/agents

- use basic option with my username and password (is in fact the API Key)

but i get the message couldn t authenticate with the credentials.

Contacted LiveChat to check whether there are issues with my credentials but if i logon to a website with the same credentials i can see data so for them there is no issue.

What needs to be done to connect to this API??

thanks

M

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Please follow below steps to get data from agents in Power BI desktop: 

1. Get Data > Web, type URL: https://api.livechatinc.com/v2/agents

2. Select Basic, type livechat username. Find API key in LiveChat profile and “My API key section”, copy and paste it in Password section. 

 

For more details, please see: https://developers.livechatinc.com/blog/how-to-get-livechat-api-data-with-microsoft-excel-or-power-b...

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Please follow below steps to get data from agents in Power BI desktop: 

1. Get Data > Web, type URL: https://api.livechatinc.com/v2/agents

2. Select Basic, type livechat username. Find API key in LiveChat profile and “My API key section”, copy and paste it in Password section. 

 

For more details, please see: https://developers.livechatinc.com/blog/how-to-get-livechat-api-data-with-microsoft-excel-or-power-b...

Best Regards,
Qiuyun Yu 

[Anonymous]

hi Qiuyun Yu,

lovely, it works!

thanks a lot!!

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Glad to hear my solution works for you. 

Would you please accept my solution as an answer? 

Best Regards,
Qiuyun Yu