I want to learn how to integrate two applications that have public APIs. I understand some of the basics, but don’t know how all the pieces are put together. I am hoping someone on here can point me towards basic, step-by-step instructions on how to do what I need to do.
To be more specific: at work we use Google sheets in the office and a task management/collaboration tool called Zenkit for data collection out in the field. I want to integrate the two applications so that data flows between them and enables us to enter data once instead of multiple times for each application.
Basically all I want is to see someone do something similar to what I want to do so that I know: the general steps, which languages I need to be familiar with, where my code would reside (website? IDE? within one of the other APIs?), and just a general overview of the whole process. Much of what I’m finding does not seem to answer my questions, or adds to my confusion. For example, will I need to make my own API to integrate the other two? I also see a lot about ‘API testing’ and honestly I don’t know if that means for testing an API that I made or testing pre-existing APIs that I want to work with.
A lot of information I find is written poorly, or is for someone who already knows these things specifically. I want an outline of the process of using APIs, not creating them. Then I can fill in any pertinent gaps in my own knowledge. Right now I keep being pulled off on tangents that may or may not end up being helpful. I just want to target my research and integrate these applications as quickly as possible.
Thank you so much for any help or suggestions you might have!