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
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file fyle-db-connector-0.14.0.tar.gz.
File metadata
- Download URL: fyle-db-connector-0.14.0.tar.gz
- Upload date:
- Size: 14.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a77349353d7ab6dee732ac2c35cc0175913dcc992fc785c32c789d582ef05410
|
|
| MD5 |
ddfe3d33b4dd56ffb30aaa2684ae4cf9
|
|
| BLAKE2b-256 |
c90cd6ad0a588d4a02915512bb55e9c1953e83bb6dbab168e25e19b017a59d12
|
File details
Details for the file fyle_db_connector-0.14.0-py3-none-any.whl.
File metadata
- Download URL: fyle_db_connector-0.14.0-py3-none-any.whl
- Upload date:
- Size: 17.2 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9f996f20b6850b1e4e7d93db57c20776725b46a756c1af4e50b7d986e40290f2
|
|
| MD5 |
271ef01837fe2cfdf51666eaa143bd24
|
|
| BLAKE2b-256 |
da84730c023be604bf3af8d592454bc3bdb4e1856592e8a9e492bb0f8afea1d4
|
