I am attempting to access the Meraki API using Rest linked service, Rest Dataset, and Copy activity within Azure Data Factory.
I receive no errors, but the response is empty. Any suggestions?
From what I understand, Azure Data Factory is a way to create workflows based on different data sources, and you are working on using the Meraki API as one of these sources?
If that sounds accurate, could you provide some more details around which API call you are making to Meraki?
If we start simple and use a service like Postman to test, are you able to get the API call results you are expecting?
Yes - I want to parse the results from various Meraki endpoints and load the output to tables for aggregated reporting.
Even just getting started with GET /organizations returns an empty response string from within data factory.
I can definitely use Postman (while connected to my company network) to test the API calls and return results for my organization, but from within Azure all I get is an empty string.
When using Azure Databricks, I seem to get an OK response from the API, but the response string is empty:
Thank you for any help, direction you can give.
Thanks for the context!
I tested the same call and syntax using the meraki python library, and it seems to be working as expected on my end.
I think the next step would be to make the same call using Postman or another method (outside of Azure) to isolate where the issue might be occurring.
Just wanted to bump the thread to see if you were able to test any of those alternative methods.
Let me know if you were able to find anything!
I can receive responses using both Postman and PyCharm with no issue.
In databricks, I continue to receive an empty string:
Got some additional error msgs - any suggestions?
"Strict-Transport-Security": "max-age=15552000; includeSubDomains",
"X-XSS-Protection": "1; mode=block",
"Cache-Control": "no-store, must-revalidate, no-cache, max-age=0",
"Date": "Wed, 06 Oct 2021 12:16:14 GMT",
"Content-Type": "text/html; charset=utf-8",
"Expires": "Fri, 01 Jan 1990 00:00:00 GMT",
"body": "<html><body>You are being <a href=\"https://n433.meraki.com/api/v1/organizations\">redirected
Thanks for the additional info @bainese !
This may require some additional troubleshooting by Meraki Support to verify some things on the Meraki end.
I'll be DMing you shortly to help get that rolling, so keep an eye out.