question

Ramin Atta avatar image
Ramin Atta asked Ramin Atta answered

Import Data Missing Asstance RC Call Logs to Sheets

Hello,

I am very new to coding, API ect.

Basically I am trying to import call log information using Zapier into a google sheet. There are data sample fields that are not coming through via Zapier that we require in order to use the data. "Result" data is the main field we need that will not zap through.

I have been told we need a custom API for that, but I have no idea where to start, nor do I understand what needs to be done once I have a custom API.

Any help provided would be appreciated.

Thanks

importhelp wantedzapiergoogle sheetsbasic
2 comments
1 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Ramin Atta avatar image Ramin Atta commented ·

The Quick start states not to use the Call Logs API for real time reporting, which is essentially what I need to do.

The API that I built from the API explorer has no record information for some reason. Does not seem to matter what date ranges I put in or sheet information.

Would there be any other way to import call log analytics data into google sheets with the results data included in real time?

0 Likes 0 ·
Phong Vu avatar image Phong Vu ♦♦ Ramin Atta commented ·

You did not mention in your question about real-time reporting. In that case, you will need to use either the telephony session notification or the presence notification API.

https://developers.ringcentral.com/api-reference/Account-Telephony-Sessions-Event

https://developers.ringcentral.com/api-reference/Extension-Telephony-Sessions-Event

https://developers.ringcentral.com/api-reference/Detailed-Extension-Presence-Event


You wrote "The API that I built from the API explorer has no record information for some reason. Does not seem to matter what date ranges I put in or sheet information."

Can you show the code who you call the API?

0 Likes 0 ·
Phong Vu avatar image
Phong Vu answered

Since you are new to everything, I recommend you try the API explorer to see what you would get from the call-log API, and also try from the code in a programming language you are familiar with.

- API Explorer: https://developers.ringcentral.com/api-reference/Call-Log/readCompanyCallLog

- Quick start: https://developers.ringcentral.com/guide/voice/call-log/reading-call-log

Also read this blog to see how the call log data can be read and parsed.

Then you can come back to ask for more specific questions so I can help you better.

1 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Ramin Atta avatar image
Ramin Atta answered

Having done some work connecting a CRM to google sheets using their API and google apps script, I've come back to try to do the same thing here, again.

All I want is to pull as many detailed company call logs from the past 24 hours until now (current time) as I can into google sheets so I can count how many dials/contacts are being completed by each sales person each day. I can't even seem to pull ANY records in the past so I'm not worried about "real time" issues. Lets pull a record first.

The CRM I was working with only has Basic Auth and RC uses Oauth2 and I'm not sure how to "upgrade" my script to this style, so I have tried another way.

The other way I tried was with API Connector but it doesn't pull any records, just like my issue posted in January.

I'm using the API builder in CURL so its pretty standard url and headers.



1 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.