Excel Editor Insomnia

Summary

• 1. Presentation
  • 1.1. SPA, API & Insomnia
  • 1.2. Diagrams
    • 1.2.1. Global architecture
• 2. How to use this repo with Insomnia ?
• 3. Upload Excel files
• 4. Resources
• 5. Comments, suggestions?
• 6. License

1. Presentation

1.1. SPA, API & Insomnia

Study of a complete application, with a SPA (Angular) and an API (Symfony), which allows users to connect, and to be able, according to their rights, to import Excel data and modify them online.

Excel Editor SPA	https://github.com/jprivet-dev/excel-editor-spa
Excel Editor API	https://github.com/jprivet-dev/excel-editor-api
Excel Editor Insomnia	https://github.com/jprivet-dev/excel-editor-insomnia

⬆ Back to top

1.2. Diagrams

1.2.1. Global architecture

⬆ Back to top

2. How to use this repo with Insomnia ?

1. Be sure to install the latest version of Insomnia.

2. Fork https://github.com/jprivet-dev/excel-editor-insomnia.git.

3. Clone the project in Insomnia:

   • Click on the Create menu, and choose Git Clone:

     

   • Authenticate with GitHub if you haven’t already done so:

     
     

   • Use the HTTPS link to your fork in GitHub URI:

     

   • Click on the button Clone. You arrive at the DESIGN tab of the project homepage:

     

4. Choose the DEBUG tab:

   

5. Choose Admin environment:

   

   💡	You can use Admin or User environment.

6. Click & Deploy Authentication folder, choose login_check request and click on Send button. You can retrieve a token:

   ⚠️	The very first time, you will have the following error: Error: SSL peer certificate or SSH remote key was not OK Click on Disable SSL Validation button and in Insomnia Preferences, uncheck Validate certificates. Close the dialog and click again on Send button.

   

7. Click & Deploy User folder, choose user request and click on Send button. You have the user attached to the token:

   

8. Click on the Personal Projects button to see the homepage with all projects:

   

⬆ Back to top

3. Upload Excel files

In the Upload folder, you can test the requests and upload the Excel files in the data folder of the Excel Editor API:

⬆ Back to top

4. Resources

• https://insomnia.rest/

• https://docs.insomnia.rest/

• https://medium.com/thefork/get-the-most-out-of-insomnia-to-effectively-test-your-api-8a81f1349ef6

⬆ Back to top

5. Comments, suggestions?

Feel free to make comments/suggestions to me in the Git issues section.

⬆ Back to top

6. License

"Excel Editor Insomnia" is released under the MIT License

---

⬆ Back to top