Custom lightning connect adapter for google sheets web-based spreadsheet program
Various embodiments concern custom adapters for Salesforce platforms that enable synchronization with an external service, such as Google Sheets. More specifically, the custom adapters can be used to read external data from a database associated with the external service, and then continually reference the external data in order to provide a live view of the external data from a Salesforce interface. Thus, the custom adapters enable real-time, live data integration without data replication. The custom adapters also allow the external data to be dynamically mapped to data object(s) that are used to create the Salesforce interface. Therefore, a user may be able to modify the external data using the Salesforce interface and an interface associated with the external service.
1. A computer-implemented method for implementing a Lightning Connect adapter for a Salesforce application development platform, the method comprising:
accessing a programming environment associated with an add-on application for a Salesforce application development platform;
calling an application programming interface (API) associated with a Google Sheets spreadsheet program from within the programming environment, wherein the calling of the API causes external data to be read from a Google Sheets database;
parsing the external data without copying the external data to an internal database of the Salesforce application development platform;
automatically formatting the external data based on the parsing, wherein the formatting ensures that the external data read from the Google Sheets database conforms to specifications of the Salesforce application development platform;
establishing a lookup relationship by dynamically mapping the external data to data objects used within the programming environment;
continually referencing the external data in the Google Sheets database and the data objects in the programming environment, wherein the continual referencing enables an external data record in the Google Sheets database to be updated in near real time when a change is made to a corresponding data object in the programming environment via a Salesforce interface, and a data object in the programming environment to be updated in near real time when a change is made to a corresponding external data record via a Google Sheets interface;
receiving input indicative of a command to modify a particular data object used in the programming environment; and
transmitting metadata indicative of the command to the Google Sheets spreadsheet program, wherein receipt of the metadata prompts the Google Sheets spreadsheet program to formulate an appropriate instruction, the execution of which implements the command on the external data in the Google Sheets database.
2. The method of claim 1 , wherein logic within the programming environment is implemented using an Apex programming language.
3. The method of claim 1 , wherein the parsing of the external data is performed by a Lightning Connect adapter that is responsible for interfacing with the API.
4. The method of claim 1 , wherein the parsing of the external data further comprises:
analyzing the external data to determine content of each cell of a spreadsheet that is represented by the external data.
5. The method of claim 4 , wherein the lookup relationship is based on the content determined to be in each cell of the spreadsheet that is represented by the external data.
6. The method of claim 1 , wherein the Salesforce interface and the Google Sheets interface are accessible via one or more of a web browser, a mobile application, a desktop program, or an over-the-top application.
7. The method of claim 1 , wherein the continually referencing enables the Salesforce interface to present a live view of the external data residing in the Google Sheets database.
8. The method of claim 1 , wherein the establishing of the lookup relationship is based at least in part on algorithmic logic that considers content of each cell of a spreadsheet that is represented by the external data, rather than column headers or row headers.
9. The method of claim 1 , wherein the change is one of:
creation of a new data record;
modification of an existing data record; or
deletion of the existing data record.
10. A non-transitory storage medium having instructions stored thereon, when executed by a processor, causing the processor to execute a method comprising:
accessing a programming environment associated with an add-on application for a Salesforce application development platform;
calling an application programming interface (API) associated with a Google Sheets spreadsheet program from within the programming environment, wherein the calling of the API causes external data to be read from a Google Sheets database;
parsing the external data without copying the external data to an internal database of the Salesforce application development platform;
automatically formatting the external data based on the parsing, wherein the formatting ensures that the external data read from the Google Sheets database conforms to specifications of the Salesforce application development platform;
establishing a lookup relationship by dynamically mapping the external data to data objects used within the programming environment;
continually referencing the external data in the Google Sheets database and the data objects in the programming environment, wherein the continual referencing enables an external data record in the Google Sheets database to be updated in near real time when a change is made to a corresponding data object in the programming environment via a Salesforce interface, and a data object in the programming environment to be updated in near real time when a change is made to a corresponding external data record via a Google Sheets interface;
receiving input indicative of a command to modify a particular data object used in the programming environment; and
transmitting metadata indicative of the command to the Google Sheets spreadsheet program, wherein receipt of the metadata prompts the Google Sheets spreadsheet program to formulate an appropriate instruction, the execution of which implements the command on the external data in the Google Sheets database.
11. The non-transitory storage medium of claim 10 , wherein the establishing of the lookup relationship is based at least in part on algorithmic logic that considers content of each cell of a spreadsheet that is represented by the external data, rather than column headers or row headers.
12. The method of claim 10 , wherein the Salesforce interface and the Google Sheets interface are accessible via one or more of a web browser, a mobile application, a desktop program, or an over-the-top application.
13. The non-transitory storage medium of claim 10 , wherein each external data record corresponds to one or more cells within a spreadsheet.
14. The method of claim 10 , wherein continually referencing enables the Salesforce interface to present a live view of the external data residing in the Google Sheets database.
15. An apparatus for synchronizing a Salesforce platform and a Google Sheets database in real time, the apparatus comprising:
a processor; and
a memory that includes instructions that, when executed by the processor, cause the processor to:
access a programming environment associated with an add-on application for a Salesforce application development platform;
call an application programming interface (API) associated with a Google Sheets spreadsheet program from within the programming environment, wherein the calling of the API causes external data to be read from a Google Sheets database;
parse the external data without copying the external data to an internal database of the Salesforce application development platform;
automatically format the external data based on the parsing, wherein the formatting ensures that the external data read from the Google Sheets database conforms to specifications of the Salesforce application development platform;
establish a lookup relationship by dynamically mapping the external data to data objects used within the programming environment;
continually reference the external data in the Google Sheets database and the data objects in the programming environment, wherein the continual referencing enables an external data record in the Google Sheets database to be updated in near real time when a change is made to a corresponding data object in the programming environment via a Salesforce interface, and a data object in the programming environment to be updated in near real time when a change is made to a corresponding external data record via a Google Sheets interface;
receive input indicative of a command to modify a particular data object used in the programming environment; and
transmit metadata indicative of the command to the Google Sheets spreadsheet program, wherein receipt of the metadata prompts the Google Sheets spreadsheet program to formulate an appropriate instruction, the execution of which implements the command on the external data in the Google Sheets database.
16. The apparatus of claim 15 , wherein the parsing of the external data is performed by a Lightning Connect adapter that is responsible for interfacing with the API.
17. The apparatus of claim 15 , wherein logic within the programming environment is implemented using an Apex programming language.
18. The apparatus of claim 15 , wherein the parsing of the external data further comprises:
analyzing the external data to determine content of each cell of a spreadsheet that is represented by the external data.
19. The apparatus of claim 18 , wherein the lookup relationship is based on the content determined to be in each cell of the spreadsheet that is represented by the external data.
20. The apparatus of claim 15 , wherein the continually referencing enables the Salesforce interface to present a live view of the external data residing in the Google Sheets database.