Power BI

Legale provides Power BI report API to summarize users' document management.
Pagination is mandatory in this API.

API detail

Request

• URL: /power-bi/?page=1&page_size=10
• Method: GET
• Query Params:

{
  "page": 1,
  "page_size": 10,  // (maximum 500)
}

Response

Success

• Status code: 200
• Body:

{
  "count": 1000,
  "next": "https://api.legale.io/api/v2/power-bi/?page=2&page_size=10",
  "previous": null,
  "results": [
    {
      "sign_process_status": 4,
      "sign_method": "certification",
      "file_name": "Anexo_de_Pago_Starbien_-_Mediclic_docx_pdf",
      "description": "",
      "GUID": "ad9dddcd-7754-49af-bc81-0c5c8aea18a1",
      "document_id": null,
      "folder_path": "root/contract/company",
      "smart_document": "Company contract default",
      "reject_reason": null,
      "reject_date": null,
      "document_url": "http://localhost:5051/media/document/ad9dddcd-7754-49af-bc81-0c5c8aea18a1/document/Anexo_de_Pago_Starbien_-_Mediclic_docx_pdf-signed.pdf",
      "evidence_url": "http://localhost:5051/document/file/ad9dddcd-7754-49af-bc81-0c5c8aea18a1/evidence/",
      "signers": [
        {
          "firstname": "Signer",
          "lastname1": "1",
          "lastname2": "",
          "email": "signer1@gmail.com",
          "started_at": "2025-10-08T17:28:56.018630Z",
          "signed_at": "2025-10-08T17:29:05.239635Z",
          "expire_at": "2025-11-07T17:28:56.015904Z"
        }
      ],
      "attached_files": [
        {
          "file": "http://localhost:5051/media/document/43a7a899-cadd-4df9-996c-2ee3fd16d840/attached/aiuon.pdf",
          "file_name": "document_id.pdf",
          "expire_date": null
        },
      ],
      "variables": [
        "Signer1",
        "signer1@legale.io",
        "12.434.534-0",
        "44",
        "Sí"
      ]
  },
  ],
}

Value	Type	Description
GUID	str	GUID of the document.
sign_process_status	int	Sign process status of the document. This is status of document that is for specified to user.
sign_method	str	Sign method of the document. This is sign method of document that is for specified to user.
file_name	str	File name of the document.
description	str	Description of the document.
document_id	str	Document ID that is specified by user.
folder_path	str	Folder path in Legale cloud, this folder path shows the location of document in user's explorer.
smart_document	str	Name of smart document that the document is created from.
reject_reason	str	Reason of reject that the rejector left.
reject_date	datetime	Reject date in UTC.
document_url	str	Full URL of the document that can be downloaded from.
evidence_url	str	Full URL of the document evidence that can be downloaded from. This URL is available in case of only document is signed.
variables	list	Smart document variable list. This is available in case of only the document is created from smart document.

• signers

Value	Type	Description
firstname	str	First name of signer
lastname1	str	First last name of signer
lastname2	str	Second last name of signer
email	str	Email of signer
started_at	datetime	Date and time when the sign process was started (in UTC)
signed_at	datetime	Date and time when the sign process was finished (in UTC). This value is available only when the signer finished sign process
expire_at	datetime	Date and time when the sign process will be expired.

• attached_files

Value	Type	Description
file	str	Full URL of the attached file that can be downloaded from.
file_name	str	File name of the attached file
lastname2	str	Second last name of signer
expire_at	datetime	Date and time when the attached file will be expired.

• sign_process_status

Value	Type	Description
0	int	Ready to send to Workspace
1	int	Ready to send to sign
2	int	Ready to sign
3	int	In sign process
4	int	Signed
5	int	Rejected
6	int	Sign flow paused
7	int	Ready to approve
8	int	Pending deletion
9	int	Ready to upload approve
10	int	Pending upload approve
11	int	Upload rejected
12	int	Flow terminated
101	int	Sign link expired

• sign_method

Value	Type	Description
sms	str	Remote sms
no_sms	str	Remote no sms
email_pin	str	Remote stamp
certification	str	Cloud certificate
local_certificate	str	Local certificate
tablet_sign	str	Mobile device
approve	str	Approve remote
approve_legale	str	Approve Legale
approve_api	str	Approve API
signing_portal	str	Signing portal
send_email	str	Send email
fea	str	FEA