I need this by the end of the week.
I have been granted access to the private API for google local (google my business).
I need to connect to the Google API either via the provided client libraries (C#) or through the REST API. I want an app, where I can enter start date and end date and it will connect to the API and bring down store location code, the total number of times the location appeared in google, the driving directions, tap to call and reviews.
I then want that information stored in a SQL server.
Database table with fields:
storecode (varchar 8)
searchtotal (int)
directionstotal (int)
callstotal (int)
reviewtottal (int)
reviewrating (float)
I have created the credentials for both client and web api through google console but i do not know how to authenticate the requests. I am not sure where the account id is found so I need someone with experience authenticating with Google.