Abstract
The article describes a comparative analysis of data reading from tables in the Salesforce environment using three different application programming interfaces. The popularity of the Salesforce platform and the release of the GraphQL interface on October 5, 2022 contributed to the study. No such study specifically for the Salesforce platform was found in the literature. The performance of reading data from the Salesforce platform was investigated using an automation script. For four tables containing a different number of rows, 8 types of queries were repeatedly executed using each of the three interfaces. It was found that depending on the number of rows, either REST API or SOAP API should be considered. In all cases, the lowest performance was observed while using GraphQL API.
Subject
Polymers and Plastics,General Environmental Science
Reference10 articles.
1. J. H. Bhatti, B. B. Rad, Databases in Cloud Computing: A literature review, International Journal of Information Technology and Computer Science 9(4) (2017) 9–17, https://doi.org/10.5815/ijitcs.2017.04.02.
2. L. A. B. Silva, C. Costa, J. L. Oliveira, A common API for delivering services over multi-vendor cloud resources, Journal of Systems and Software 86(9) (2013) 2309–2317, https://doi.org/10.1016/j.jss.2013.04.037.
3. Dokumentacja interfejsów programowania aplikacji w Salesforce, https://developer.salesforce.com/docs/apis , [04.04.2023].
4. Ranking systemów CRM dla roku 2023, https://www.pcmag.com/picks/the-best-crm-software , [04.04.2023].
5. Dokumentacja Salesforce dotycząca GraphQL, https://developer.salesforce.com/docs/platform/graphql/references/graphql?meta=Summary , [04.04.2023].