Connects Fyle to a database connector to transfer information to and fro.
Project description
Fyle Database Connector
Connects Fyle to a database to transfer information to and fro. Fyle is an expense management system.
Installation
This project requires Python 3+.
-
Download this project and use it (copy it in your project, etc).
-
Install it from pip.
$ pip install fyle-db-connector
Usage
To use this connector you'll need these Fyle credentials used for OAuth2 authentication: client ID, client secret and refresh token.
This connector is very easy to use.
- First you'll need to create a connection using the main class FyleSDK.
import sqlite3
from fylesdk import FyleSDK
from fyle_db_connector import FyleExtractConnector
dbconn = sqlite3.connect('/tmp/temp.db')
connection = FyleSDK(
base_url='<BASE_URL>',
client_id="<CLIENT_ID>",
client_secret='<CLIENT_SECRET>',
refresh_token='<REFRESH_TOKEN>'
)
fyle_extract = FyleExtractConnector(
fyle_sdk_connection=connection,
dbconn=dbconn
)
- After that you'll be able to extract data from fyle and store it in the db
# Create the tables to for all objects
fyle_extract.create_tables()
fyle_extract.extract_expenses(state=['PAYMENT_PROCESSING'])
fyle_extract.extract_settlements()
fyle_extract.extract_employees()
fyle_extract.extract_reimbursements()
fyle_extract.extract_advances()
fyle_extract.extract_advance_requests(state=['PAID'])
fyle_extract.extract_projects()
fyle_extract.extract_cost_centers()
fyle_extract.extract_categories()
Contribute
To contribute to this project follow the steps
- Fork and clone the repository.
- Run
pip install -r requirements.txt
- Setup pylint precommit hook
- Create a file
.git/hooks/pre-commit
- Copy and paste the following lines in the file -
#!/usr/bin/env bash git-pylint-commit-hook
- Run
chmod +x .git/hooks/pre-commit
- Create a file
License
This project is licensed under the MIT License - see the LICENSE file for details
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
fyle-db-connector-0.9.0.tar.gz
(13.5 kB
view hashes)
Built Distribution
Close
Hashes for fyle_db_connector-0.9.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d0a21146ce150e15a64eda763c7c636069bf7276c1c8b9d48b07899d306d0a9f |
|
MD5 | 0be05dcad9a69966efcca228b7a84c15 |
|
BLAKE2b-256 | 6928d265a927f273b7a88af75125f5825363cf71936cd49b08c3a11109e8534e |