Skip to main content

Sankhya Data Extraction MVP

Sankhya is one of Brazil's leading ERP (Enterprise Resource Planning) platforms, offering business management solutions ranging from financial control to CRM and human resources management. This project aims to facilitate data extraction from the platform through its API.

Contents​

About the project​

This MVP was developed specifically to facilitate data extraction from Sankhya using CRUDServiceProvider.loadRecords. It serves as a preliminary version of a future connector. Using this framework with a specific set of parameters, users can extract data from multiple modules and entities associated with that service.

Prerequisites​

  • Python 3.x
  • Required libraries: requests, json, logging, os

Configuration​

Environment Variables:​

  • SANKHYA_TOKEN
  • SANKHYA_APPKET
  • SANKHYA_USERNAME
  • SANKHYA_PASSWORD

Extraction Parameters:​

  • Module: The Sankhya platform module from which you want to extract data.
  • Service Name: The specific service to access for extraction.
  • Entity: The specific entity within the module. For example: "Produto".
  • Resources: The entity resources or fields to extract. Use * to extract all available fields.
  • Output Variable Name: The output name to use in the next step.

Note: By default, we use these parameters:

  • Module = mge;
  • Service Name = "CRUDServiceProvider.loadRecords"
  • Entity = "Produto"
  • Resources = "CODPROD,DESCRPROD,LOCAL,MARCA,CODVOL"

References​

  • API documentation