What's missing in my conf with the Shopify connect...
# ask-ai
m
What's missing in my conf with the Shopify connecter ? The BULK Job:
<gid://shopify/BulkOperation/4990127538521>
exited with FAILED, details: {\"data\":{\"node\":{\"id\":\"gid://shopify/BulkOperation/4990127538521\",\"status\":\"FAILED\",\"errorCode\":\"ACCESS_DENIED\",\"createdAt\":\"2024-06-04T093853Z\",\"objectCount\":\"0\",\"fileSize\":null,\"url\":null,\"partialDataUrl\":null}},\"extensions\":{\"cost\":{\"requestedQueryCost\":1,\"actualQueryCost\":1,\"throttleStatus\":{\"maximumAvailable\":4000.0,\"currentlyAvailable\":3999,\"restoreRate\":200.0}}}}
k
It looks like your Shopify connector is encountering an
ACCESS_DENIED
error during a BULK job. This error typically indicates that there is an issue with the permissions or access rights for the Shopify API. Here are a few steps you can take to troubleshoot and resolve this issue: 1. Check API Credentials: Ensure that the API credentials (API key and password) you are using for the Shopify connector have the necessary permissions to perform bulk operations. You may need to generate new credentials with the appropriate access rights. 2. Review Shopify App Permissions: Verify that the Shopify app you are using has the required permissions. The app should have read and write access to the data you are trying to fetch. 3. Firewall Settings: Make sure that your firewall settings are not blocking the connection to Shopify. This has been a common issue as noted in the [forum post](https://discuss.airbyte.io/t/2636): > "Which is caused (mostly) for Firewall configuration." 4. Connector Version: Ensure you are using the latest version of the Shopify connector. There have been updates and fixes in recent versions that might resolve your issue. For example, a recent issue with empty fields was fixed in the latest version as mentioned in the [GitHub issue](https://github.com/airbytehq/airbyte/issues/30543): > "This is fixed in the most recent version of connector so can be closed." 5. Check Logs: Review the logs for any additional error messages or details that might provide more context on why the access is being denied. This can help pinpoint the exact cause of the issue. If you have verified all the above and the issue persists, you may want to reach out to Shopify support to ensure there are no account-specific restrictions or issues. For more detailed troubleshooting, you can refer to the [Airbyte documentation](https://docs.airbyte.com/) or the [Shopify API documentation](https://shopify.dev/docs/admin-api). If you need further assistance, feel free to provide more details or check the Airbyte community forums for similar issues.
m
@kapa.ai What's the needed permission ? 1. Check API Credentials: Ensure that the API credentials (API key and password) you are using for the Shopify connector have the necessary permissions to perform bulk operations. You may need to generate new credentials with the appropriate access rights.
k
To ensure that the API credentials (API key and password) you are using for the Shopify connector have the necessary permissions to perform bulk operations, you need to follow these steps: 1. Create a Shopify Private App: - Log into your Shopify dashboard and click on Apps in the sidebar menu. - Click on the Manage private apps link at the bottom of the page. - If you have not enabled private apps previously, click on the Enable private app development button. - Accept Shopify’s terms on private app development usage and click on Enable private app development once again. - Click on the Create private app button to get started. - In the App details section, fill in the private app name and emergency developer email. - Go to the Admin API section and perform the following: - Click on the Show inactive Admin API permissions dropdown, and locate the Order API in the list. Then, grant Read access from the select box. - Locate Shopify Payments disputes and Shopify Payments payouts, and grant those as well. - Click on the Save button to save your new private app. - Confirm the creation of the private app by clicking on the Create app button in the confirmation modal. - Scroll down to the Admin API section and copy your private app API password. 2. Set Up the Airbyte Shopify Connector: - Head over to the Airbyte web UI dashboard and provide the Shopify connector configuration form with the password you just copied. - In the Airbyte UI, paste in the password you copied from Shopify and then hit Set up Source. For more detailed instructions, you can refer to the [Airbyte tutorial on setting up the Shopify connector](https://airbyte.com/tutorials/implement-machine-learning-for-your-shopify-store-with-mindsdb#step-1). Additionally, ensure that your API credentials have the necessary permissions to access the required data. For example, the API key needs to have
Read
and
Configuration Access
permissions to enable the connector to correctly load data, as mentioned in the [Opsgenie setup guide](https://docs.airbyte.com/integrations/sources/opsgenie#setup-guide). By following these steps, you can ensure that your API credentials have the necessary permissions to perform bulk operations with the Shopify connector.