Raise error if API returns a code other than what is expected

What does this MR do?

Currently, the script silently fails and continue with the next step incase the API responds with a non 2xx code. This MR fixes that.

Does this MR meet the acceptance criteria?

Conformity

• [-] Changelog entry
• [-] Documentation created/updated or follow-up review issue created
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content