Trying to fetch Jira issues with Azure Data factory

Question

Hi,

I am trying to use Azure data factory to fetch Jira ssues through REST API, checked connection works fine. But received error message when I click preview data:

Here is the base URL and related URL

Base URL: https://emergingtechnologypartners.atlassian.net/rest/api/3/

Related URL: search?jql=project=SD&startAt=0&maxResults=3&validateQuery=strict&fields=resolution

As you can see, the base URL ends with '/'. When I combined the base and related URL in browser, it works and returned the issues. Can someone help to check how I can adjust the dataset configurations? Thanks.

Best regards,

Bo

Answer 1

Hi Bo Xiao ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

As per my understanding , you are trying to make a REST API call using Azure data factory, however, it's failing with error. It would be great if you could share your pipeline configuration so far for enabling us to reproduce your error. Is that publicly accessible API? or does it need any authentication.

It seems the query parameter in the relative URL is not valid, the API is giving only the below data . The REST API is fetching the data if we use upto 'search?' as can be seen in browser as well.

If I hit the baseURL concatinating the relative URL which you have shared, it is throwing the below error:

Kindly check with the source team and see if the query parameter in relative URL is valid or not. Additionally, if it is valid , then definitely, the REST API is missing the data.

Hope it helps. Kindly share additional details such as pipeline screenshot for further assistance. In case it helped, kindly accept the answer by clicking on Accept answer button. Thankyou