Discussions (English)

Registered 11 years 293 days

Uros 1135 Thursday, 20 May 2021, 08:49 AM

Api for getting CSV from reporting

Hello

can you help me understand how to do authenticatin if I do not use PHP? In your exp you have already written class for php auth but I do not know what kind of call must be made, which params must I set if different program language then php is used.
your wiki for php:
http://wiki.innovaphone.com/index.php?title=Reference13r1:Concept_Talking_to_the_v13_Application_Platform_using_PHP#Authentication_3

What I need to do is to get csv file from reporting app via API. http://wiki.innovaphone.com/index.php?title=Reference13r1:Concept_App_Service_Reporting

For getting session and a key but always be websocket call first after i am authenticated?

Registered 12 years 233 days

Tobias 847 Thursday, 20 May 2021, 08:59 AM

Re: Api for getting CSV from reporting

Hi Uros,

with the csv i can't help you.

At a few customers i connect directly to the recording postgre sql DB, maybe this is an easyer solution ;)

Registered 11 years 293 days

Uros 1135 Thursday, 20 May 2021, 09:30 AM

Re: Api for getting CSV from reporting

Hi Tobias

so there is no option like this: http://AP-IP/DOMAIN/reporting/reports/report-20200408-1015.csv?session=189&key=552ca6fe05a19&lang=de&tz=Europe/Berlin&type=csv&sip=&from=1586304000000&to=1586333749607

ok, if DB is only option that is fine with me

Can you point me how this can be done

thank you

Moderator

Registered 15 years 114 days

Daniel Deterding (innovaphone) Thursday, 20 May 2021, 09:37 AM

Re: Api for getting CSV from reporting

Hi Uros,

the wiki describes how to get a CSV in combination with a websocket connection:

http://wiki.innovaphone.com/index.php?title=Reference13r1:Concept_App_Service_Reporting#Write_an_own_app

There is now way to generate a CSV without a websocket connection.

Greetings,

Daniel

Registered 12 years 233 days

Tobias 847 Thursday, 20 May 2021, 09:45 AM in response to Uros 1135

Re: Api for getting CSV from reporting

Hi, have a look here:

http://wiki.innovaphone.com/index.php?title=Reference13r1:Concept_App_Service_Reporting

http://wiki.innovaphone.com/index.php?title=Reference13r1:Concept_App_Platform#Database

Registered 11 years 293 days

Uros 1135 Thursday, 20 May 2021, 10:21 AM

Re: Api for getting CSV from reporting

Hi Tobias

i read that

Before I do websocket connection i have to be authorized to get some token i guess. And this is the thing that I do not know how to do that as everything is wirtten already in PHP which does not give me API definition.

Here I hope you will come in place and help me figure it out how to do that

thank you

miha

Registered 11 years 293 days

Uros 1135 Monday, 24 May 2021, 10:32 AM in response to Tobias 847

Re: Api for getting CSV from reporting

@Tobias can you please help me with this, how to do auth so that i get cdrs?

Uros

Registered 12 years 233 days

Tobias 847 Tuesday, 25 May 2021, 08:46 AM

Re: Api for getting CSV from reporting

Hi Uros,

sorry, never done this with websocet and so on..

I only did the direct access to the postgresSQL DB.

good luck!

Registered 11 years 293 days

Uros 1135 Tuesday, 25 May 2021, 09:11 AM

Re: Api for getting CSV from reporting

@tobias but who will be the right one who can help with this?

or how to do it via postgreSQL? i guess i need to allow first remote connection on linux app, then i need to have username/password for auth and table structure?

Registered 12 years 233 days

Tobias 847 Tuesday, 25 May 2021, 09:22 AM

Re: Api for getting CSV from reporting

Hi,

I guess, that youre running a V13 reporting app or?

http://wiki.innovaphone.com/index.php?title=Reference13r1:Concept_App_Service_Reporting#Database_access

http://wiki.innovaphone.com/index.php?title=Reference13r1:Concept_App_Platform#Database

Attatched a view from the PGAdmin with DB access

postgres.png

You are here