get Google AppScript Code working
Budget: $10 – $30 USD
Hi,
I am attempting to run a Google App Script code, but I am having trouble getting it to work. I require assistance in getting it to function properly.
The script's purpose is simple. It should issue a GET request to the Cisco Meraki API and retrieve four values for a network client based on its MAC address. The four values are the client's description, IP address, status, and lastSeen on the network. These values should then be written into a Google Sheet.
The API itself is functional and authentication works correctly, as I have verified using Postman. The GET request operates without issue on Postman, and both the cURL and API responses are available from Postman. Access to the Google Script and App Script are granted, allowing for the code to be quickly debugged and resolved.
Documentation to access an external API from AppsScript:
https://developers.google.com/apps-script/guides/services/external
Meraki API Documentation
https://developer.cisco.com/meraki/api-latest/
I am attempting to run a Google App Script code, but I am having trouble getting it to work. I require assistance in getting it to function properly.
The script's purpose is simple. It should issue a GET request to the Cisco Meraki API and retrieve four values for a network client based on its MAC address. The four values are the client's description, IP address, status, and lastSeen on the network. These values should then be written into a Google Sheet.
The API itself is functional and authentication works correctly, as I have verified using Postman. The GET request operates without issue on Postman, and both the cURL and API responses are available from Postman. Access to the Google Script and App Script are granted, allowing for the code to be quickly debugged and resolved.
Documentation to access an external API from AppsScript:
https://developers.google.com/apps-script/guides/services/external
Meraki API Documentation
https://developer.cisco.com/meraki/api-latest/