Try to set Data type as JSON and Use as “DATA”.
If you have privacy for the database table then add your API key to the Authorization header on API Connector.
thank you for your feedback. i will try that as well. however i talked with API provider. their server blocked me for some reason and they said they have to fix it from their side.