Week 5 : Mautic Marketplace : Updating the data and look into endpoints

Welcome to week 5

On week 5 I tried the upsert and we noticed that upsert is useful to avoid the data duplication.

The data is inserted and when I run the script again, I check to make sure that the data is not repeated or duplicated.

We have to give the onConflict in the script on that condition where upsert performs!
Basically, what we right in onConflict that is followed as unique

Then I began conversing with my mentors about endpoints! I already created some end points and I'm testing those endpoints and others but then we found out that supabase has a built-in rest API

The supabase auto generates the endpoint data with the database schema and we can see those on API Docs section

This is accessed by URL and ANON_KEY with this format

https://<PROJECT_REF>.supabase.co/rest/v1/todos?apikey=<ANON_KEY>

 
and we decided to use that instead of creating every endpoint manually

After verifying the functionality of various built-in rest API endpoints, we attempted to fetch various data, and it was successful

Next Week:

For next week we plan to see the cron job so that we don't have to run the script manually!

Anything you want to ask related to my project, please do comment below! 

Thanks for your valuable time!