-- GET the API data after midnight of every day
Set a default of "" empty string - just in case the INSERT INTO cards do not match
E.g. the 3rd one did not have a copyright
PUT the API call into db cards table
Match titles from API with column names
Remove column titles "copyright" :
Remove { at the start and } at the beginning and the end
Trim each value using trim()
For example -- Receiving and testing
-- GET the API data after midnight of every day Set a default of "" empty string - just in case the INSERT INTO cards do not match E.g. the 3rd one did not have a copyright
PUT the API call into db cards table
Match titles from API with column names Remove column titles "copyright" :
Remove { at the start and } at the beginning and the end Trim each value using trim()