Hi everyone, I´m trying to extract info from Tempo in Jira. Currently, I´m using Jira connector (Jira Query), but in the data source, I can't watch the Tempo Time sheet entity. Does someone know how we would extract info from tempo? Thanks

Matillion ETL
1

Hi everyone,
I´m trying to extract info from Tempo in Jira. Currently, I´m using Jira connector (Jira Query), but in the data source, I can’t watch the Tempo Time sheet entity.
Does someone know how we would extract info from tempo? Thanks

2

Hi @david.solorzano​

Thank you for your post, have you been able to achieve this? I wanted to share our documentation for the Jira Query Component that could help, if not, just let me know and we can take a more in-depth look at this for you.

Kind regards, Joe

3

@david.solorzano (Customer)

Use Python component to achieve it follow these steps below,

To extract data from Tempo in Jira:

  1. Refer to Tempo API: Check Tempo's API documentation for accessing timesheet data directly.
  2. Authentication: Obtain necessary authentication credentials (API token or OAuth).
  3. API Requests: Utilize tools like cURL or Python's
  4. requests
  5. library to make HTTP requests to Tempo API endpoints.
  6. Data Processing: Parse and process the retrieved data as per your needs.
  7. Automation: Consider automating data extraction using scripts or scheduling tools.

I'm used this method to connect it, I may also source code for your reference :

import requests

api_token = "your_api_token"

headers = {"Authorization": f"Bearer {api_token}