Trying to fetch Jira issues with Azure Data factory

Bo Xiao 61 Reputation points
2023-07-26T04:03:16.3966667+00:00

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:

User's image

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,078 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 29,586 Reputation points Microsoft Employee
    2023-07-26T06:46:27.58+00:00

    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.

    User's image

    User's image

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

    User's image

    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