python and cli Client for providing access to micros2 microservice after authtication from tokenleader
Project description
# micros1-client
python and cli client for accessing the api routes from micros1 micro service
installation
=====================================
virtualenv -p python3 venv
source venv/bin/activate
pip install micros1client
alternate to run from source
git clone https://github.com/microservice-tsp-billing/micros1-client.git
cd micros-client1
virtualenv -p python3 venv
source venv/bin/activate
pip install -r requirement.txt
config
===============================================================
Follow readme for configuring the tokenleaderclient first - https://github.com/microservice-tsp-billing/tokenleaderclient
apart from the tokenleaderclient configuration the following sections should be present in the /etc/tokenleader/client_configs.yml
micros1:
url_type: endpoint_url_external
ssl_enabled: no
ssl_verify: no
hence the complete configuraion will look as:
user_auth_info_from: file # OSENV or file
user_auth_info_file_location: /home/bhujay/tlclient/user_settings.ini
fernet_key_file: /home/bhujay/tlclient/prod_farnetkeys
tl_public_key: ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCYV9y94je6Z9N0iarh0xNrE3IFGrdktV2TLfI5h60hfd9yO7L9BZtd94/r2L6VGFSwT/dhBR//CwkIuue3RW23nbm2OIYsmsijBSHtm1/2tw/0g0UbbneM9vFt9ciCjdq3W4VY8I6iQ7s7v98qrtRxhqLc/rH2MmfERhQaMQPaSnMaB59R46xCtCnsJ+OoZs5XhGOJXJz8YKuCw4gUs4soRMb7+k7F4wADseoYuwtVLoEmSC+ikbmPZNWOY18HxNrSVJOvMH2sCoewY6/GgS/5s1zlWBwV/F0UvmKoCTf0KcNHcdzXbeDU9/PkGU/uItRYVfXIWYJVQZBveu7BYJDR bhujay@DESKTOP-DTA1VEB
tl_user: user1
tl_url: http://localhost:5001
ssl_verify: False
micros1:
url_type: endpoint_url_external
ssl_enabled: no
ssl_verify: no
consult with the tokenleader administrator to replace the values in the above values :
1. get the correct public key
2. To register your username
3. To assign a role
4. In the micros1 server the role name to be mapped with the api route permission for the following
- tokenleader.adminops.adminops_restapi.list_users
- linkInventory.restapi.routes.get_links_rest
- linkInventory.restapi.routes.get_link_by_slno
- micros1.ms2app.restapi.firstapi.ep3
- micros1.create_invoice
- micros1.upload_excel
- micros1.list_all
- micros1.delete_all
- micros1.update_invoice
- micros1.recommend_change
- micros1.accept_recom
- micros1.approve_invoice
- micros1.reject_invoice
5. user tokneleader get token to see the service catalog and identify the correct url_type for micros1 which is reachable from your client
PYTHON client
===================================
from tokenleaderclient.configs.config_handler import Configs
from tokenleaderclient.client.client import Client
from micros1client.client import MSClient
auth_config = Configs()
tlclient = Client(auth_config)
c = MSClient(tlclient)
c.ep3()
To upload invoices from the excel( excel need to be comply with the format)
c.upload_xl('/mnt/c/mydev/temp/micros1.xlsx')
c.list_invoices_clo('invoiceno', '<actual invoice number>')
To list a single invoice with all history documents:
c.list_invoices_clo('invoiceno', '1234HH')
To list all invoices with (clo) current, last and older history:
c.list_invoices_clo('all', 'all')
To list invoices where city is Nagpur or division is DiVISON1 with current and last change history:
c.list_invoices_clo('city', 'Nagpur')
c.list_invoices_clo('division', 'DIVISION1')
To update invoice, the same excel and same format is needed which was used for uploading.
Change the column values as needed and use - c.update_invoice(('/mnt/c/mydev/temp/micros1.xlsx')
c.update_invoice_xl(('/mnt/c/mydev/temp/micros1.xlsx')
while uploading the changes following conditions apply:
1. There is a TSP name column in the excel. The name must match the org name that was given by the
tokenleader admin while registering the tsp as a user of this application.
2. TSP can view adn update only their invoices , however this restriction is not there for user='user1'
3. Changes will be compared with the last invoice and no modification will be done unless any changes are detected
4. Changes can not be done unless document status is set to 'changeSuggested'. TODO: this feature to be enabled once
workflow for change recommendation is completed.
TODO: delete can be done only when invoices are marked for deletion
To delete one single invoice , type the invoice number
To delete all invoices c.delete_invoices('all')
c.delete_invoices('<actual invoice number>')
c.delete_invoices('all')
import json
from tokenleaderclient.configs.config_handler import Configs
from tokenleaderclient.client.client import Client
from micros2client.client import MSClient
auth_config = Configs()
tlclient = Client(auth_config)
c = MSClient(tlclient)
c = MSClient(tlclient)
p = '../micros2/micros2/tests/testdata/list_datarec.json'
with open(p) as f:
d=json.load(f)
c.save_tesprec(d)
c.list_invoices('invoiceno', '002', 1)
c.list_invoices('all', 'all', 1)
c.delete_invoices('all')
c.list_invoices_clo('city', 'Nagpur')
c.list_invoices_clo('all', 'all')
c.list_invoices_clo('invoiceno', '1')
list_invoices('invoiceno', '1', 1)
l = ['1', '2', '3', '4' , '5']
c.approve_invoices(l)
c.delete_invoices('4444')
c.delete_invoices('all')
CLI client
=========================
./micros1.sh ep3
or
python micros1.sh uploadxl -f /mnt/c/mydev/temp/micros1.xlsx
python micros1.sh list -k all -v all
python micros1.sh list -k processing_status -v waiting_in_queue
python micros1.sh list -k Speed -v '512 Kbps'
python micros1.sh delete -k City -v Hariyana
python micros1.sh delete -i <invoice number>
or when the client was installed through pip , no need to type 'python'
micros1 ep3
micros1 uploadxl -f /mnt/c/mydev/temp/micros1.xlsx
micros1 listclo -k all -v all
micros1 update -f /mnt/c/mydev/temp/micros1.xlsx
micros1 delete -i <invoice number>
sample input data for recommendation
===============================================
from tokenleaderclient.configs.config_handler import Configs
from tokenleaderclient.client.client import Client
from micros1client.client import MSClient
auth_config = Configs()
tlclient = Client(auth_config)
c = MSClient(tlclient)
c.ep3()
test_xl_dict = {'SLNo': 1, 'TSP': 'TATA', 'CustomerID': 'customerid',
'CustomerName': 'customername', 'InvoiceNo': '1',
'AccountNo': '12345', 'CircuitID': 'circuitid',
'Speed': 'speed', 'ARC': 'arc', 'GSTNo': 'gstno',
'Division': 'divission', 'BillingDateFrom': '12-12-2018',
'BillingDateTO': '01-03-2019', 'InvoiceDate': '01-04-2019',
'TaxName': 'taxnameccc', 'Total': 100, 'ServiceType': 'MPLS',
'City': 'city23', 'State': 'state2', 'PIN': 12345, 'PremiseNo': 'premno',
'PremiseName': 'premnamerecomm', 'SiteID': 'siteid',
'FullSiteAddress': 'fullsiteaddrress', 'REMARKS': 'remarks',
}
listdata = [test_xl_dict, ]
c.create_invoice_list(listdata)
c.recommend_changes(listdata)
list_of_invnum = ['2', ]
c.accept_recom(list_of_invnum)
sample return data structure , so that you can use the key , values for processing the data or dashboard development
========================================================================================
invoice_list = c.list_invoices_clo('all', 'all')
will provide a list of dictionaries . for each item in list represets an unique invoice having multile histories
pick up the current , last and older history as below
invoice1 = c[0]
invoice1_current_data = invoice1['current_doc']
invoice1_current_data
#{'revnum': 1, 'xldata': {'state': 'GG', 'arc': '2400', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'This looks like a good address', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-12-2018', 'speed': '5 mbps', 'division': 'POPCompany', 'taxname': 'USA SGST@9%+CGST@9%', 'total': 234455, 'accountno': 'XDN038414', 'pin': 52454, 'circuitid': '6798KJJL', 'invoicedate': '15-03-2019', 'invoiceno': '11111111111', 'siteid': '52454', 'gstno': '09AAJJ888899N90', 'premiseno': '52454', 'city': 'Gujrat', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 1, 'premisename': '52454'}, 'creation_time': {'$date': 1553348096452}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}
invoice1_last_data = invoice1['last_doc']
invoice1_last_data
#{'revnum': 0, 'xldata': {'state': 'GG', 'arc': '2400', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'This looks like a good address', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-12-2018', 'speed': '5 mbps', 'division': 'POPCompany', 'taxname': 'USA SGST@9%+CGST@9%', 'total': 234455, 'accountno': 'XDN038414', 'pin': 52454, 'circuitid': '6798KJJLKHHJKH', 'invoicedate': '15-03-2019', 'invoiceno': '11111111111', 'siteid': '52454', 'gstno': '09AAJJ888899N90', 'premiseno': '52454', 'city': 'Gujrat', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 1, 'premisename': '52454'}, 'creation_time': {'$date': 1553346530618}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}
or you can loop through the list to get the details for each invoice
for i in invoice_list:
invoice1_current_data = i['current_doc']
invoice1_last_data = i['last_doc']
[ { 'current_doc': { 'revnum': 1,
'xldata': { 'state': 'GG',
'arc': '2400',
'billingdateto': '01-03-2019',
'remarks': 'OK',
'fullsiteaddress': 'This looks like a good address',
'customerid': 'XI000555',
'servicetype': 'GXDN',
'billingdatefrom': '02-12-2018',
'speed': '5 mbps',
'division': 'POPCompany',
'taxname': 'USA SGST@9%+CGST@9%',
'total': 234455, 'accountno':
'XDN038414',
'pin': 52454,
'circuitid': '6798KJJL',
'invoicedate': '15-03-2019',
'invoiceno': '11111111111',
'siteid': '52454',
'gstno': '09AAJJ888899N90',
'premiseno': '52454',
'city': 'Gujrat',
'tsp': 'TATA',
'customername': 'ABC Limited',
'slno': 1, 'premisename': '52454'
},
'creation_time': {'$date': 1553348096452},
'auditinfo': { 'logged_in_user_dept': 'dept1',
'client_address': '127.0.0.1',
'logged_in_user_org': 'org1',
'logged_in_user_email': 'user1',
'api_call_time_stamp': {'$date': 1553348096173},
'logged_in_user_org_unit': 'ou1',
'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'
},
status': 'ChangedByTSP'},
'last_doc': { 'revnum': 0,
'xldata': {'state': 'GG', 'arc': '2400', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'This looks like a good address', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-12-2018', 'speed': '5 mbps', 'division': 'POPCompany', 'taxname': 'USA SGST@9%+CGST@9%', 'total': 234455, 'accountno': 'XDN038414', 'pin': 52454, 'circuitid': '6798KJJLKHHJKH', 'invoicedate': '15-03-2019', 'invoiceno': '11111111111', 'siteid': '52454', 'gstno': '09AAJJ888899N90', 'premiseno': '52454', 'city': 'Gujrat', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 1, 'premisename': '52454'}, 'creation_time': {'$date': 1553346530618}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'KA', 'arc': '765500', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '65 Hempstead Turnpike, East Meadow NY 11554', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '10 Mbps', 'division': 'DIVISON1', 'taxname': ' GErmany SGST SGST@9%+CGST@9%', 'total': 12234, 'accountno': 'XDN043451', 'pin': 5245, 'circuitid': 'LJLKJKJKGJ5454', 'invoicedate': '15-03-2019', 'invoiceno': '22222222222', 'siteid': '5245', 'gstno': '08KJHLHLHLH88879', 'premiseno': '5245', 'city': 'Gujrat', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 2, 'premisename': '5245'}, 'creation_time': {'$date': 1553348096552}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'KA', 'arc': '765500', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '65 Hempstead Turnpike, East Meadow NY 11554', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '18 Mbps', 'division': 'DIVISON1', 'taxname': ' GErmany SGST SGST@9%+CGST@9%', 'total': 12234, 'accountno': 'XDN043451', 'pin': 5245, 'circuitid': 'LJLKJKJKGJ5454', 'invoicedate': '15-03-2019', 'invoiceno': '22222222222', 'siteid': '5245', 'gstno': '08KJHLHLHLH88879', 'premiseno': '5245', 'city': 'Gujrat', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 2, 'premisename': '5245'}, 'creation_time': {'$date': 1553346530627}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'ff', 'arc': '98987', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1 Centereach Mall, Centereach NY 11720', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '100 Mbps', 'division': 'DIVISON1', 'taxname': 'Bhopal SGST@9%+CGST@9%', 'total': 8765, 'accountno': 'XDN005555', 'pin': 5245, 'circuitid': 'SJJJJ796976858523', 'invoicedate': '15-03-2019', 'invoiceno': '3333333333', 'siteid': '5245', 'gstno': '86LJKJJJJJ7789797', 'premiseno': '5245', 'city': 'Gujrat', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 3, 'premisename': '5245'}, 'creation_time': {'$date': 1553346530634}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'fdaf', 'arc': '76555', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1 Washington Ave Extension, Albany NY 12205', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '11 Mbps', 'division': 'DIVISON1', 'taxname': 'Kunnur SGST@9%+CGST@9%', 'total': 2345, 'accountno': 'XDN045164', 'pin': 95, 'circuitid': 'KPK96334', 'invoicedate': '15-03-2019', 'invoiceno': '44444444444', 'siteid': '95', 'gstno': 'YYYY887766', 'premiseno': '95', 'city': 'Nagpur', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 4, 'premisename': '95'},
'creation_time': {'$date': 1553346530647},
'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'},
'status': 'initialUpload'},
'older_history': [],
},
{ 'current_doc': {'revnum': 1, 'xldata': {'state': 'fadf', 'arc': '70000', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1180 Fall River Avenue, Seekonk MA 2771', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-01-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Rajasthan SGST@9%+CGST@9%', 'total': 987, 'accountno': 'XDN054596', 'pin': 5989, 'circuitid': 'JIJH685TFD33', 'invoicedate': '15-03-2019', 'invoiceno': '55555555555', 'siteid': '5989', 'gstno': '68MLJKLJKJ99', 'premiseno': '5989', 'city': 'Nagpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 5, 'premisename': '5989'}, 'creation_time': {'$date': 1553348096706}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '70000', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1180 Fall River Avenue, Seekonk MA 2771', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-01-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Rajasthan SGST@9%+CGST@9%', 'total': 987, 'accountno': 'XDN054596', 'pin': 5989, 'circuitid': 'JIJH685TFD33', 'invoicedate': '15-03-2019', 'invoiceno': '55555555555', 'siteid': '5989', 'gstno': '68MLJKLJKJ', 'premiseno': '5989', 'city': 'Nagpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 5, 'premisename': '5989'}, 'creation_time': {'$date': 1553346530653}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 2, 'xldata': {'state': 'fadf', 'arc': '75444', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '777 Brockton Avenue, Abington MA 2351', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-02-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ganja Park SGST@9%+CGST@9%', 'total': 134456, 'accountno': 'XDN004785', 'pin': 989, 'circuitid': 'HIH543LKK', 'invoicedate': '15-03-2019', 'invoiceno': '6666666666', 'siteid': '989', 'gstno': '95JHJHJHJJJ', 'premiseno': '989', 'city': 'Nagpur', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 6, 'premisename': '989'}, 'creation_time': {'$date': 1553348311927}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348311584}, 'logged_in_user_org_unit': 'ou1', 'requestid': '3b1ed68b-d17c-4a01-877c-9e2e531b6d21'}, 'status': 'ChangedByTSP'}, 'older_history': [{'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '75444', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '777 Brockton Avenue, Abington MA 2351', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ganja Park SGST@9%+CGST@9%', 'total': 134456, 'accountno': 'XDN004785', 'pin': 989, 'circuitid': 'HIH543LKKLK', 'invoicedate': '15-03-2019', 'invoiceno': '6666666666', 'siteid': '989', 'gstno': '95JHJHJHJJJ', 'premiseno': '989', 'city': 'Nagpur', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 6, 'premisename': '989'}, 'creation_time': {'$date': 1553346530665}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}], 'last_doc': {'revnum': 1, 'xldata': {'state': 'fadf', 'arc': '75444', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '777 Brockton Avenue, Abington MA 2351', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-02-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ganja Park SGST@9%+CGST@9%', 'total': 134456, 'accountno': 'XDN004785', 'pin': 989, 'circuitid': 'HIH543LKKLK', 'invoicedate': '15-03-2019', 'invoiceno': '6666666666', 'siteid': '989', 'gstno': '95JHJHJHJJJ', 'premiseno': '989', 'city': 'Nagpur', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 6, 'premisename': '989'}, 'creation_time': {'$date': 1553348096802}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '776858', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '30 Memorial Drive, Avon MA 2322', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Sodepur SGST@9%+CGST@9%', 'total': 34567, 'accountno': 'XDN045166', 'pin': 5772, 'circuitid': 'JLKJ7976579', 'invoicedate': '15-03-2019', 'invoiceno': '77777777777', 'siteid': '5772', 'gstno': '79BJHGBS5ERE', 'premiseno': '5772', 'city': 'Nagpur', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 7, 'premisename': '5772'}, 'creation_time': {'$date': 1553346530682}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '333333', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '250 Rt 59, Airmont NY 10901', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Rajasthan SGST@9%+CGST@9%', 'total': 345678, 'accountno': 'XDN006904', 'pin': 14543, 'circuitid': 'OJH6855868', 'invoicedate': '15-03-2019', 'invoiceno': '88888888888', 'siteid': '14543', 'gstno': '65JKHJHHJ', 'premiseno': '14543', 'city': 'Jabbalpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 8, 'premisename': '14543'}, 'creation_time': {'$date': 1553346530686}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '123456', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1180 Fall River Avenue, Seekonk MA 2771', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Uttar Pradesh SGST@9%+CGST@9%', 'total': 654313, 'accountno': 'XDN005967', 'pin': 4134, 'circuitid': 'NKHKJ796765765', 'invoicedate': '15-03-2019', 'invoiceno': '99999999999', 'siteid': '4134', 'gstno': '68NJJKHJOJ', 'premiseno': '4134', 'city': 'AHMEDABAD', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 9, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530692}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '3567', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '550 Providence Hwy, Walpole MA 2081', 'customerid': 'XI000555', 'servicetype': 'ETHERNET', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'DIVISON1s', 'taxname': 'West Bengal SGST@9%+CGST@9%', 'total': 1345, 'accountno': 'ETH000936', 'pin': 14, 'circuitid': 'MLJHUT75447JN', 'invoicedate': '15-03-2019', 'invoiceno': '555566666666', 'siteid': '14', 'gstno': '85HKHJKHJKHLH', 'premiseno': '14', 'city': 'Kerala', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 10, 'premisename': '14'}, 'creation_time': {'$date': 1553346530696}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '45678', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '4133 Veterans Memorial Drive, Batavia NY 14020', 'customerid': 'XI000555', 'servicetype': 'ETHERNET', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'YOURDIVISION', 'taxname': 'West Bengal SGST@9%+CGST@9%', 'total': 9876, 'accountno': 'ETH033653', 'pin': 341, 'circuitid': 'K;LKHHIIGI6', 'invoicedate': '15-03-2019', 'invoiceno': '66666677777777', 'siteid': '341', 'gstno': '432HHHLOUIUTUYG', 'premiseno': '341', 'city': 'Kerala', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 11, 'premisename': '341'}, 'creation_time': {'$date': 1553346530702}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '23347', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '8064 Brewerton Rd, Cicero NY 13039', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '10 Mbps', 'division': 'DIVISON1', 'taxname': 'Gujarat SGST@9%+CGST@9%', 'total': 23487, 'accountno': 'XDN005237', 'pin': 13434, 'circuitid': 'JLKJ66875657676', 'invoicedate': '15-03-2019', 'invoiceno': '54524524652656', 'siteid': '13434', 'gstno': '58NJKNKJNKLNKL', 'premiseno': '13434', 'city': 'Vellore', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 12, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530706}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'WB', 'arc': '2245678', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'Steel Authority of India Ltd.\n Ispat Bhavan\n Lodhi Road\n GURGAON\n 110003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDNN', 'billingdatefrom': '02-04-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ethopia SGST@9%+CGST@9%', 'total': 5987, 'accountno': 'XDN086220', 'pin': 4314, 'circuitid': 'LKJOHHKJG858585', 'invoicedate': '15-03-2019', 'invoiceno': '75676767647', 'siteid': '4314', 'gstno': '36GFJGJHHKJH', 'premiseno': '4314', 'city': 'MYCITY', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 13, 'premisename': '4314'}, 'creation_time': {'$date': 1553348096965}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '2245678', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'Steel Authority of India Ltd.\n Ispat Bhavan\n Lodhi Road\n GURGAON\n 110003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ethopia SGST@9%+CGST@9%', 'total': 5987, 'accountno': 'XDN086220', 'pin': 4314, 'circuitid': 'LKJOHHKJG858585', 'invoicedate': '15-03-2019', 'invoiceno': '75676767647', 'siteid': '4314', 'gstno': '36GFJGJHHKJH', 'premiseno': '4314', 'city': 'MYCITY', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 13, 'premisename': '4314'}, 'creation_time': {'$date': 1553346530712}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '132355', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'Department of Posts\n Business Development Directorate\n Dak Bhavana\n Parliament Street\n NEW DELHI 110001\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Africa SGST@9%+CGST@9%', 'total': 1265, 'accountno': 'XDN090733', 'pin': 4134, 'circuitid': 'MLKJJKGJGJHL54635M6LK53J', 'invoicedate': '15-03-2019', 'invoiceno': '7676476765', 'siteid': '4134', 'gstno': '4765HLJNLKJJH', 'premiseno': '4134', 'city': 'Amritsar', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 14, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530716}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 924\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '512 Kbps', 'division': 'DIVISON1', 'taxname': 'Maharashtra SGST@9%+CGST@9%', 'total': 7654, 'accountno': 'XDN011222', 'pin': 14, 'circuitid': 'MSKLJNK6L5336', 'invoicedate': '15-03-2019', 'invoiceno': '7676746764', 'siteid': '14', 'gstno': '8JKLL;K;LKL;KK', 'premiseno': '14', 'city': 'Patna', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 15, 'premisename': '14'}, 'creation_time': {'$date': 1553346530719}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '345667', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '63, EddieGunj, Raipur - 251616', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Sundarbanra SGST@9%+CGST@9%', 'total': 345987, 'accountno': 'XDN005627', 'pin': 341, 'circuitid': ',;LSFJM;L637653', 'invoicedate': '15-03-2019', 'invoiceno': '6767676u76', 'siteid': '341', 'gstno': 'GR354253GKJKJL', 'premiseno': '341', 'city': 'Munnar', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 16, 'premisename': '341'}, 'creation_time': {'$date': 1553346530723}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '21335', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '87, Naval Apartments, Navami Chowk Darjeeling - 221298', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'MYDIVISION', 'taxname': 'KEralara SGST@9%+CGST@9%', 'total': 234654, 'accountno': 'XDN005880', 'pin': 13434, 'circuitid': 'JOKJOJGSR7987896', 'invoicedate': '15-03-2019', 'invoiceno': '4674676764', 'siteid': '13434', 'gstno': '346GHHJKHKLJL', 'premiseno': '13434', 'city': 'Munnar', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 17, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530728}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '12356', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '7, Jamshed Heights, Bandra Gandhinagar - 571769', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 mbps', 'division': 'DIVISON1', 'taxname': 'Maharashtra SGST@9%+CGST@9%', 'total': 6534567, 'accountno': 'XDN005980', 'pin': 4314, 'circuitid': 'KJPJOJJL;JK75365', 'invoicedate': '15-03-2019', 'invoiceno': '67674676', 'siteid': '4314', 'gstno': '97NKLNKLJKLJKJ', 'premiseno': '4314', 'city': 'Munnar', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 18, 'premisename': '4314'}, 'creation_time': {'$date': 1553346530737}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '5790', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Karnataka SGST@9%+CGST@9%', 'total': 6234, 'accountno': 'XDN045165', 'pin': 4134, 'circuitid': 'MLKJLKJJOJKJLJL', 'invoicedate': '15-03-2019', 'invoiceno': '6767676', 'siteid': '4134', 'gstno': 'LKJOJ9886786M', 'premiseno': '4134', 'city': 'Bhgalpur', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 19, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530744}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'TL', 'arc': '4567890', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '55, MalikGunj, Bhopal - 29055', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Karnataka SGST@9%+CGST@9%', 'total': 34796, 'accountno': 'XDN006558', 'pin': 14, 'circuitid': 'JHHKHKLGJFSGJSKJGSF', 'invoicedate': '15-03-2019', 'invoiceno': '674567676', 'siteid': '14', 'gstno': 'KJ768768768', 'premiseno': '14', 'city': 'Bhgalpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 20, 'premisename': '14'}, 'creation_time': {'$date': 1553348097135}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '4567890', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '55, MalikGunj, Bhopal - 29055', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Karnataka SGST@9%+CGST@9%', 'total': 3476, 'accountno': 'XDN006558', 'pin': 14, 'circuitid': 'JHHKHKLGJFSGJSKJGSF', 'invoicedate': '15-03-2019', 'invoiceno': '674567676', 'siteid': '14', 'gstno': 'KJ768768768', 'premiseno': '14', 'city': 'Bhgalpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 20, 'premisename': '14'}, 'creation_time': {'$date': 1553346530750}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '23467', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Tamil nadu SGST@9%+CGST@9%', 'total': 765234, 'accountno': 'XDN006114', 'pin': 341, 'circuitid': 'MLKKHKGSFHSFGLKSFJLG', 'invoicedate': '15-03-2019', 'invoiceno': '6767674', 'siteid': '341', 'gstno': '776GHHKJHLKJ;', 'premiseno': '341', 'city': 'Calicut', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 21, 'premisename': '341'}, 'creation_time': {'$date': 1553346530766}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '1223456', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '7 Mbps', 'division': 'DIVISON1', 'taxname': 'Tamil nadu SGST@9%+CGST@9%', 'total': 34565, 'accountno': 'XDN007146', 'pin': 13434, 'circuitid': 'NJJHHJJHHJLHKH', 'invoicedate': '15-03-2019', 'invoiceno': '55635635635', 'siteid': '13434', 'gstno': 'HIJH6', 'premiseno': '13434', 'city': 'Calicut', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 22, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530792}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '12345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 2345654, 'accountno': 'XDN080776', 'pin': 4314, 'circuitid': 'HHJH686765765765', 'invoicedate': '15-03-2019', 'invoiceno': '65265653', 'siteid': '4314', 'gstno': '36AAACI5950L1ZB', 'premiseno': '4314', 'city': 'Hariyana', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 23, 'premisename': '4314'}, 'creation_time': {'$date': 1553346530798}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '7654', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '58, Deccan Gymkhana, Hisar - 483009', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 987, 'accountno': 'XDN080776', 'pin': 4134, 'circuitid': '765GKJHJKJLKJ', 'invoicedate': '15-03-2019', 'invoiceno': '656565', 'siteid': '4134', 'gstno': '36AAACI5950L1ZB', 'premiseno': '4134', 'city': 'Hariyana', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 23, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530809}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '1345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 924\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '8 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 4784578, 'accountno': 'XDN080776', 'pin': 14, 'circuitid': '78576NLMLKL;KK', 'invoicedate': '15-03-2019', 'invoiceno': '524656535', 'siteid': '14', 'gstno': '36AAACI5950L1ZB', 'premiseno': '14', 'city': 'Hariyana', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 23, 'premisename': '14'}, 'creation_time': {'$date': 1553346530813}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '12345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '8064 Brewerton Rd, Cicero NY 13039', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 65, 'accountno': 'XDN118720', 'pin': 341, 'circuitid': 'JJHTTRUY56586', 'invoicedate': '15-03-2019', 'invoiceno': '452748796', 'siteid': '341', 'gstno': 'HKJJHH79879798', 'premiseno': '341', 'city': 'Hariyana', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 24, 'premisename': '341'}, 'creation_time': {'$date': 1553346530817}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'HY', 'arc': '76543', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 9244\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 1234, 'accountno': 'XDN118720', 'pin': 13434, 'circuitid': 'NKJHHHS', 'invoicedate': '15-03-2019', 'invoiceno': '769680', 'siteid': '13434', 'gstno': '78979HJJLKJ', 'premiseno': '13434', 'city': 'Hariyana', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 24, 'premisename': '13434'}, 'creation_time': {'$date': 1553348097327}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '76543', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 924\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 1234, 'accountno': 'XDN118720', 'pin': 13434, 'circuitid': 'NKJHHHS', 'invoicedate': '15-03-2019', 'invoiceno': '769680', 'siteid': '13434', 'gstno': '78979HJJLKJ', 'premiseno': '13434', 'city': 'Hariyana', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 24, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530823}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}
]
l = '/mydev/microservice-tsp-billing/micros1/micros1/tests/testdata/sample_inv_upload.xlsx'
p = 'C:\mydev\microservice-tsp-billing\micros1\micros1\tests\testdata\sample_inv_upload.xlsx'
from pathlib import Path
P = Path(p)
L = Path(l)
python and cli client for accessing the api routes from micros1 micro service
installation
=====================================
virtualenv -p python3 venv
source venv/bin/activate
pip install micros1client
alternate to run from source
git clone https://github.com/microservice-tsp-billing/micros1-client.git
cd micros-client1
virtualenv -p python3 venv
source venv/bin/activate
pip install -r requirement.txt
config
===============================================================
Follow readme for configuring the tokenleaderclient first - https://github.com/microservice-tsp-billing/tokenleaderclient
apart from the tokenleaderclient configuration the following sections should be present in the /etc/tokenleader/client_configs.yml
micros1:
url_type: endpoint_url_external
ssl_enabled: no
ssl_verify: no
hence the complete configuraion will look as:
user_auth_info_from: file # OSENV or file
user_auth_info_file_location: /home/bhujay/tlclient/user_settings.ini
fernet_key_file: /home/bhujay/tlclient/prod_farnetkeys
tl_public_key: ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCYV9y94je6Z9N0iarh0xNrE3IFGrdktV2TLfI5h60hfd9yO7L9BZtd94/r2L6VGFSwT/dhBR//CwkIuue3RW23nbm2OIYsmsijBSHtm1/2tw/0g0UbbneM9vFt9ciCjdq3W4VY8I6iQ7s7v98qrtRxhqLc/rH2MmfERhQaMQPaSnMaB59R46xCtCnsJ+OoZs5XhGOJXJz8YKuCw4gUs4soRMb7+k7F4wADseoYuwtVLoEmSC+ikbmPZNWOY18HxNrSVJOvMH2sCoewY6/GgS/5s1zlWBwV/F0UvmKoCTf0KcNHcdzXbeDU9/PkGU/uItRYVfXIWYJVQZBveu7BYJDR bhujay@DESKTOP-DTA1VEB
tl_user: user1
tl_url: http://localhost:5001
ssl_verify: False
micros1:
url_type: endpoint_url_external
ssl_enabled: no
ssl_verify: no
consult with the tokenleader administrator to replace the values in the above values :
1. get the correct public key
2. To register your username
3. To assign a role
4. In the micros1 server the role name to be mapped with the api route permission for the following
- tokenleader.adminops.adminops_restapi.list_users
- linkInventory.restapi.routes.get_links_rest
- linkInventory.restapi.routes.get_link_by_slno
- micros1.ms2app.restapi.firstapi.ep3
- micros1.create_invoice
- micros1.upload_excel
- micros1.list_all
- micros1.delete_all
- micros1.update_invoice
- micros1.recommend_change
- micros1.accept_recom
- micros1.approve_invoice
- micros1.reject_invoice
5. user tokneleader get token to see the service catalog and identify the correct url_type for micros1 which is reachable from your client
PYTHON client
===================================
from tokenleaderclient.configs.config_handler import Configs
from tokenleaderclient.client.client import Client
from micros1client.client import MSClient
auth_config = Configs()
tlclient = Client(auth_config)
c = MSClient(tlclient)
c.ep3()
To upload invoices from the excel( excel need to be comply with the format)
c.upload_xl('/mnt/c/mydev/temp/micros1.xlsx')
c.list_invoices_clo('invoiceno', '<actual invoice number>')
To list a single invoice with all history documents:
c.list_invoices_clo('invoiceno', '1234HH')
To list all invoices with (clo) current, last and older history:
c.list_invoices_clo('all', 'all')
To list invoices where city is Nagpur or division is DiVISON1 with current and last change history:
c.list_invoices_clo('city', 'Nagpur')
c.list_invoices_clo('division', 'DIVISION1')
To update invoice, the same excel and same format is needed which was used for uploading.
Change the column values as needed and use - c.update_invoice(('/mnt/c/mydev/temp/micros1.xlsx')
c.update_invoice_xl(('/mnt/c/mydev/temp/micros1.xlsx')
while uploading the changes following conditions apply:
1. There is a TSP name column in the excel. The name must match the org name that was given by the
tokenleader admin while registering the tsp as a user of this application.
2. TSP can view adn update only their invoices , however this restriction is not there for user='user1'
3. Changes will be compared with the last invoice and no modification will be done unless any changes are detected
4. Changes can not be done unless document status is set to 'changeSuggested'. TODO: this feature to be enabled once
workflow for change recommendation is completed.
TODO: delete can be done only when invoices are marked for deletion
To delete one single invoice , type the invoice number
To delete all invoices c.delete_invoices('all')
c.delete_invoices('<actual invoice number>')
c.delete_invoices('all')
import json
from tokenleaderclient.configs.config_handler import Configs
from tokenleaderclient.client.client import Client
from micros2client.client import MSClient
auth_config = Configs()
tlclient = Client(auth_config)
c = MSClient(tlclient)
c = MSClient(tlclient)
p = '../micros2/micros2/tests/testdata/list_datarec.json'
with open(p) as f:
d=json.load(f)
c.save_tesprec(d)
c.list_invoices('invoiceno', '002', 1)
c.list_invoices('all', 'all', 1)
c.delete_invoices('all')
c.list_invoices_clo('city', 'Nagpur')
c.list_invoices_clo('all', 'all')
c.list_invoices_clo('invoiceno', '1')
list_invoices('invoiceno', '1', 1)
l = ['1', '2', '3', '4' , '5']
c.approve_invoices(l)
c.delete_invoices('4444')
c.delete_invoices('all')
CLI client
=========================
./micros1.sh ep3
or
python micros1.sh uploadxl -f /mnt/c/mydev/temp/micros1.xlsx
python micros1.sh list -k all -v all
python micros1.sh list -k processing_status -v waiting_in_queue
python micros1.sh list -k Speed -v '512 Kbps'
python micros1.sh delete -k City -v Hariyana
python micros1.sh delete -i <invoice number>
or when the client was installed through pip , no need to type 'python'
micros1 ep3
micros1 uploadxl -f /mnt/c/mydev/temp/micros1.xlsx
micros1 listclo -k all -v all
micros1 update -f /mnt/c/mydev/temp/micros1.xlsx
micros1 delete -i <invoice number>
sample input data for recommendation
===============================================
from tokenleaderclient.configs.config_handler import Configs
from tokenleaderclient.client.client import Client
from micros1client.client import MSClient
auth_config = Configs()
tlclient = Client(auth_config)
c = MSClient(tlclient)
c.ep3()
test_xl_dict = {'SLNo': 1, 'TSP': 'TATA', 'CustomerID': 'customerid',
'CustomerName': 'customername', 'InvoiceNo': '1',
'AccountNo': '12345', 'CircuitID': 'circuitid',
'Speed': 'speed', 'ARC': 'arc', 'GSTNo': 'gstno',
'Division': 'divission', 'BillingDateFrom': '12-12-2018',
'BillingDateTO': '01-03-2019', 'InvoiceDate': '01-04-2019',
'TaxName': 'taxnameccc', 'Total': 100, 'ServiceType': 'MPLS',
'City': 'city23', 'State': 'state2', 'PIN': 12345, 'PremiseNo': 'premno',
'PremiseName': 'premnamerecomm', 'SiteID': 'siteid',
'FullSiteAddress': 'fullsiteaddrress', 'REMARKS': 'remarks',
}
listdata = [test_xl_dict, ]
c.create_invoice_list(listdata)
c.recommend_changes(listdata)
list_of_invnum = ['2', ]
c.accept_recom(list_of_invnum)
sample return data structure , so that you can use the key , values for processing the data or dashboard development
========================================================================================
invoice_list = c.list_invoices_clo('all', 'all')
will provide a list of dictionaries . for each item in list represets an unique invoice having multile histories
pick up the current , last and older history as below
invoice1 = c[0]
invoice1_current_data = invoice1['current_doc']
invoice1_current_data
#{'revnum': 1, 'xldata': {'state': 'GG', 'arc': '2400', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'This looks like a good address', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-12-2018', 'speed': '5 mbps', 'division': 'POPCompany', 'taxname': 'USA SGST@9%+CGST@9%', 'total': 234455, 'accountno': 'XDN038414', 'pin': 52454, 'circuitid': '6798KJJL', 'invoicedate': '15-03-2019', 'invoiceno': '11111111111', 'siteid': '52454', 'gstno': '09AAJJ888899N90', 'premiseno': '52454', 'city': 'Gujrat', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 1, 'premisename': '52454'}, 'creation_time': {'$date': 1553348096452}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}
invoice1_last_data = invoice1['last_doc']
invoice1_last_data
#{'revnum': 0, 'xldata': {'state': 'GG', 'arc': '2400', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'This looks like a good address', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-12-2018', 'speed': '5 mbps', 'division': 'POPCompany', 'taxname': 'USA SGST@9%+CGST@9%', 'total': 234455, 'accountno': 'XDN038414', 'pin': 52454, 'circuitid': '6798KJJLKHHJKH', 'invoicedate': '15-03-2019', 'invoiceno': '11111111111', 'siteid': '52454', 'gstno': '09AAJJ888899N90', 'premiseno': '52454', 'city': 'Gujrat', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 1, 'premisename': '52454'}, 'creation_time': {'$date': 1553346530618}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}
or you can loop through the list to get the details for each invoice
for i in invoice_list:
invoice1_current_data = i['current_doc']
invoice1_last_data = i['last_doc']
[ { 'current_doc': { 'revnum': 1,
'xldata': { 'state': 'GG',
'arc': '2400',
'billingdateto': '01-03-2019',
'remarks': 'OK',
'fullsiteaddress': 'This looks like a good address',
'customerid': 'XI000555',
'servicetype': 'GXDN',
'billingdatefrom': '02-12-2018',
'speed': '5 mbps',
'division': 'POPCompany',
'taxname': 'USA SGST@9%+CGST@9%',
'total': 234455, 'accountno':
'XDN038414',
'pin': 52454,
'circuitid': '6798KJJL',
'invoicedate': '15-03-2019',
'invoiceno': '11111111111',
'siteid': '52454',
'gstno': '09AAJJ888899N90',
'premiseno': '52454',
'city': 'Gujrat',
'tsp': 'TATA',
'customername': 'ABC Limited',
'slno': 1, 'premisename': '52454'
},
'creation_time': {'$date': 1553348096452},
'auditinfo': { 'logged_in_user_dept': 'dept1',
'client_address': '127.0.0.1',
'logged_in_user_org': 'org1',
'logged_in_user_email': 'user1',
'api_call_time_stamp': {'$date': 1553348096173},
'logged_in_user_org_unit': 'ou1',
'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'
},
status': 'ChangedByTSP'},
'last_doc': { 'revnum': 0,
'xldata': {'state': 'GG', 'arc': '2400', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'This looks like a good address', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-12-2018', 'speed': '5 mbps', 'division': 'POPCompany', 'taxname': 'USA SGST@9%+CGST@9%', 'total': 234455, 'accountno': 'XDN038414', 'pin': 52454, 'circuitid': '6798KJJLKHHJKH', 'invoicedate': '15-03-2019', 'invoiceno': '11111111111', 'siteid': '52454', 'gstno': '09AAJJ888899N90', 'premiseno': '52454', 'city': 'Gujrat', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 1, 'premisename': '52454'}, 'creation_time': {'$date': 1553346530618}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'KA', 'arc': '765500', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '65 Hempstead Turnpike, East Meadow NY 11554', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '10 Mbps', 'division': 'DIVISON1', 'taxname': ' GErmany SGST SGST@9%+CGST@9%', 'total': 12234, 'accountno': 'XDN043451', 'pin': 5245, 'circuitid': 'LJLKJKJKGJ5454', 'invoicedate': '15-03-2019', 'invoiceno': '22222222222', 'siteid': '5245', 'gstno': '08KJHLHLHLH88879', 'premiseno': '5245', 'city': 'Gujrat', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 2, 'premisename': '5245'}, 'creation_time': {'$date': 1553348096552}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'KA', 'arc': '765500', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '65 Hempstead Turnpike, East Meadow NY 11554', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '18 Mbps', 'division': 'DIVISON1', 'taxname': ' GErmany SGST SGST@9%+CGST@9%', 'total': 12234, 'accountno': 'XDN043451', 'pin': 5245, 'circuitid': 'LJLKJKJKGJ5454', 'invoicedate': '15-03-2019', 'invoiceno': '22222222222', 'siteid': '5245', 'gstno': '08KJHLHLHLH88879', 'premiseno': '5245', 'city': 'Gujrat', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 2, 'premisename': '5245'}, 'creation_time': {'$date': 1553346530627}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'ff', 'arc': '98987', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1 Centereach Mall, Centereach NY 11720', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '100 Mbps', 'division': 'DIVISON1', 'taxname': 'Bhopal SGST@9%+CGST@9%', 'total': 8765, 'accountno': 'XDN005555', 'pin': 5245, 'circuitid': 'SJJJJ796976858523', 'invoicedate': '15-03-2019', 'invoiceno': '3333333333', 'siteid': '5245', 'gstno': '86LJKJJJJJ7789797', 'premiseno': '5245', 'city': 'Gujrat', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 3, 'premisename': '5245'}, 'creation_time': {'$date': 1553346530634}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'fdaf', 'arc': '76555', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1 Washington Ave Extension, Albany NY 12205', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '11 Mbps', 'division': 'DIVISON1', 'taxname': 'Kunnur SGST@9%+CGST@9%', 'total': 2345, 'accountno': 'XDN045164', 'pin': 95, 'circuitid': 'KPK96334', 'invoicedate': '15-03-2019', 'invoiceno': '44444444444', 'siteid': '95', 'gstno': 'YYYY887766', 'premiseno': '95', 'city': 'Nagpur', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 4, 'premisename': '95'},
'creation_time': {'$date': 1553346530647},
'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'},
'status': 'initialUpload'},
'older_history': [],
},
{ 'current_doc': {'revnum': 1, 'xldata': {'state': 'fadf', 'arc': '70000', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1180 Fall River Avenue, Seekonk MA 2771', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-01-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Rajasthan SGST@9%+CGST@9%', 'total': 987, 'accountno': 'XDN054596', 'pin': 5989, 'circuitid': 'JIJH685TFD33', 'invoicedate': '15-03-2019', 'invoiceno': '55555555555', 'siteid': '5989', 'gstno': '68MLJKLJKJ99', 'premiseno': '5989', 'city': 'Nagpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 5, 'premisename': '5989'}, 'creation_time': {'$date': 1553348096706}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '70000', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1180 Fall River Avenue, Seekonk MA 2771', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-01-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Rajasthan SGST@9%+CGST@9%', 'total': 987, 'accountno': 'XDN054596', 'pin': 5989, 'circuitid': 'JIJH685TFD33', 'invoicedate': '15-03-2019', 'invoiceno': '55555555555', 'siteid': '5989', 'gstno': '68MLJKLJKJ', 'premiseno': '5989', 'city': 'Nagpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 5, 'premisename': '5989'}, 'creation_time': {'$date': 1553346530653}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 2, 'xldata': {'state': 'fadf', 'arc': '75444', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '777 Brockton Avenue, Abington MA 2351', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-02-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ganja Park SGST@9%+CGST@9%', 'total': 134456, 'accountno': 'XDN004785', 'pin': 989, 'circuitid': 'HIH543LKK', 'invoicedate': '15-03-2019', 'invoiceno': '6666666666', 'siteid': '989', 'gstno': '95JHJHJHJJJ', 'premiseno': '989', 'city': 'Nagpur', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 6, 'premisename': '989'}, 'creation_time': {'$date': 1553348311927}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348311584}, 'logged_in_user_org_unit': 'ou1', 'requestid': '3b1ed68b-d17c-4a01-877c-9e2e531b6d21'}, 'status': 'ChangedByTSP'}, 'older_history': [{'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '75444', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '777 Brockton Avenue, Abington MA 2351', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ganja Park SGST@9%+CGST@9%', 'total': 134456, 'accountno': 'XDN004785', 'pin': 989, 'circuitid': 'HIH543LKKLK', 'invoicedate': '15-03-2019', 'invoiceno': '6666666666', 'siteid': '989', 'gstno': '95JHJHJHJJJ', 'premiseno': '989', 'city': 'Nagpur', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 6, 'premisename': '989'}, 'creation_time': {'$date': 1553346530665}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}], 'last_doc': {'revnum': 1, 'xldata': {'state': 'fadf', 'arc': '75444', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '777 Brockton Avenue, Abington MA 2351', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-02-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ganja Park SGST@9%+CGST@9%', 'total': 134456, 'accountno': 'XDN004785', 'pin': 989, 'circuitid': 'HIH543LKKLK', 'invoicedate': '15-03-2019', 'invoiceno': '6666666666', 'siteid': '989', 'gstno': '95JHJHJHJJJ', 'premiseno': '989', 'city': 'Nagpur', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 6, 'premisename': '989'}, 'creation_time': {'$date': 1553348096802}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '776858', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '30 Memorial Drive, Avon MA 2322', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Sodepur SGST@9%+CGST@9%', 'total': 34567, 'accountno': 'XDN045166', 'pin': 5772, 'circuitid': 'JLKJ7976579', 'invoicedate': '15-03-2019', 'invoiceno': '77777777777', 'siteid': '5772', 'gstno': '79BJHGBS5ERE', 'premiseno': '5772', 'city': 'Nagpur', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 7, 'premisename': '5772'}, 'creation_time': {'$date': 1553346530682}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'fadf', 'arc': '333333', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '250 Rt 59, Airmont NY 10901', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Rajasthan SGST@9%+CGST@9%', 'total': 345678, 'accountno': 'XDN006904', 'pin': 14543, 'circuitid': 'OJH6855868', 'invoicedate': '15-03-2019', 'invoiceno': '88888888888', 'siteid': '14543', 'gstno': '65JKHJHHJ', 'premiseno': '14543', 'city': 'Jabbalpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 8, 'premisename': '14543'}, 'creation_time': {'$date': 1553346530686}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '123456', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '1180 Fall River Avenue, Seekonk MA 2771', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Uttar Pradesh SGST@9%+CGST@9%', 'total': 654313, 'accountno': 'XDN005967', 'pin': 4134, 'circuitid': 'NKHKJ796765765', 'invoicedate': '15-03-2019', 'invoiceno': '99999999999', 'siteid': '4134', 'gstno': '68NJJKHJOJ', 'premiseno': '4134', 'city': 'AHMEDABAD', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 9, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530692}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '3567', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '550 Providence Hwy, Walpole MA 2081', 'customerid': 'XI000555', 'servicetype': 'ETHERNET', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'DIVISON1s', 'taxname': 'West Bengal SGST@9%+CGST@9%', 'total': 1345, 'accountno': 'ETH000936', 'pin': 14, 'circuitid': 'MLJHUT75447JN', 'invoicedate': '15-03-2019', 'invoiceno': '555566666666', 'siteid': '14', 'gstno': '85HKHJKHJKHLH', 'premiseno': '14', 'city': 'Kerala', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 10, 'premisename': '14'}, 'creation_time': {'$date': 1553346530696}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '45678', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '4133 Veterans Memorial Drive, Batavia NY 14020', 'customerid': 'XI000555', 'servicetype': 'ETHERNET', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'YOURDIVISION', 'taxname': 'West Bengal SGST@9%+CGST@9%', 'total': 9876, 'accountno': 'ETH033653', 'pin': 341, 'circuitid': 'K;LKHHIIGI6', 'invoicedate': '15-03-2019', 'invoiceno': '66666677777777', 'siteid': '341', 'gstno': '432HHHLOUIUTUYG', 'premiseno': '341', 'city': 'Kerala', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 11, 'premisename': '341'}, 'creation_time': {'$date': 1553346530702}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '23347', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '8064 Brewerton Rd, Cicero NY 13039', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '10 Mbps', 'division': 'DIVISON1', 'taxname': 'Gujarat SGST@9%+CGST@9%', 'total': 23487, 'accountno': 'XDN005237', 'pin': 13434, 'circuitid': 'JLKJ66875657676', 'invoicedate': '15-03-2019', 'invoiceno': '54524524652656', 'siteid': '13434', 'gstno': '58NJKNKJNKLNKL', 'premiseno': '13434', 'city': 'Vellore', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 12, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530706}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'WB', 'arc': '2245678', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'Steel Authority of India Ltd.\n Ispat Bhavan\n Lodhi Road\n GURGAON\n 110003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDNN', 'billingdatefrom': '02-04-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ethopia SGST@9%+CGST@9%', 'total': 5987, 'accountno': 'XDN086220', 'pin': 4314, 'circuitid': 'LKJOHHKJG858585', 'invoicedate': '15-03-2019', 'invoiceno': '75676767647', 'siteid': '4314', 'gstno': '36GFJGJHHKJH', 'premiseno': '4314', 'city': 'MYCITY', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 13, 'premisename': '4314'}, 'creation_time': {'$date': 1553348096965}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '2245678', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'Steel Authority of India Ltd.\n Ispat Bhavan\n Lodhi Road\n GURGAON\n 110003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 mbps', 'division': 'DIVISON1', 'taxname': 'Ethopia SGST@9%+CGST@9%', 'total': 5987, 'accountno': 'XDN086220', 'pin': 4314, 'circuitid': 'LKJOHHKJG858585', 'invoicedate': '15-03-2019', 'invoiceno': '75676767647', 'siteid': '4314', 'gstno': '36GFJGJHHKJH', 'premiseno': '4314', 'city': 'MYCITY', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 13, 'premisename': '4314'}, 'creation_time': {'$date': 1553346530712}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '132355', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': 'Department of Posts\n Business Development Directorate\n Dak Bhavana\n Parliament Street\n NEW DELHI 110001\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Africa SGST@9%+CGST@9%', 'total': 1265, 'accountno': 'XDN090733', 'pin': 4134, 'circuitid': 'MLKJJKGJGJHL54635M6LK53J', 'invoicedate': '15-03-2019', 'invoiceno': '7676476765', 'siteid': '4134', 'gstno': '4765HLJNLKJJH', 'premiseno': '4134', 'city': 'Amritsar', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 14, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530716}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 924\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '512 Kbps', 'division': 'DIVISON1', 'taxname': 'Maharashtra SGST@9%+CGST@9%', 'total': 7654, 'accountno': 'XDN011222', 'pin': 14, 'circuitid': 'MSKLJNK6L5336', 'invoicedate': '15-03-2019', 'invoiceno': '7676746764', 'siteid': '14', 'gstno': '8JKLL;K;LKL;KK', 'premiseno': '14', 'city': 'Patna', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 15, 'premisename': '14'}, 'creation_time': {'$date': 1553346530719}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '345667', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '63, EddieGunj, Raipur - 251616', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Sundarbanra SGST@9%+CGST@9%', 'total': 345987, 'accountno': 'XDN005627', 'pin': 341, 'circuitid': ',;LSFJM;L637653', 'invoicedate': '15-03-2019', 'invoiceno': '6767676u76', 'siteid': '341', 'gstno': 'GR354253GKJKJL', 'premiseno': '341', 'city': 'Munnar', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 16, 'premisename': '341'}, 'creation_time': {'$date': 1553346530723}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '21335', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '87, Naval Apartments, Navami Chowk Darjeeling - 221298', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'MYDIVISION', 'taxname': 'KEralara SGST@9%+CGST@9%', 'total': 234654, 'accountno': 'XDN005880', 'pin': 13434, 'circuitid': 'JOKJOJGSR7987896', 'invoicedate': '15-03-2019', 'invoiceno': '4674676764', 'siteid': '13434', 'gstno': '346GHHJKHKLJL', 'premiseno': '13434', 'city': 'Munnar', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 17, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530728}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '12356', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '7, Jamshed Heights, Bandra Gandhinagar - 571769', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 mbps', 'division': 'DIVISON1', 'taxname': 'Maharashtra SGST@9%+CGST@9%', 'total': 6534567, 'accountno': 'XDN005980', 'pin': 4314, 'circuitid': 'KJPJOJJL;JK75365', 'invoicedate': '15-03-2019', 'invoiceno': '67674676', 'siteid': '4314', 'gstno': '97NKLNKLJKLJKJ', 'premiseno': '4314', 'city': 'Munnar', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 18, 'premisename': '4314'}, 'creation_time': {'$date': 1553346530737}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '5790', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Karnataka SGST@9%+CGST@9%', 'total': 6234, 'accountno': 'XDN045165', 'pin': 4134, 'circuitid': 'MLKJLKJJOJKJLJL', 'invoicedate': '15-03-2019', 'invoiceno': '6767676', 'siteid': '4134', 'gstno': 'LKJOJ9886786M', 'premiseno': '4134', 'city': 'Bhgalpur', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 19, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530744}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'TL', 'arc': '4567890', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '55, MalikGunj, Bhopal - 29055', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Karnataka SGST@9%+CGST@9%', 'total': 34796, 'accountno': 'XDN006558', 'pin': 14, 'circuitid': 'JHHKHKLGJFSGJSKJGSF', 'invoicedate': '15-03-2019', 'invoiceno': '674567676', 'siteid': '14', 'gstno': 'KJ768768768', 'premiseno': '14', 'city': 'Bhgalpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 20, 'premisename': '14'}, 'creation_time': {'$date': 1553348097135}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '4567890', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '55, MalikGunj, Bhopal - 29055', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Karnataka SGST@9%+CGST@9%', 'total': 3476, 'accountno': 'XDN006558', 'pin': 14, 'circuitid': 'JHHKHKLGJFSGJSKJGSF', 'invoicedate': '15-03-2019', 'invoiceno': '674567676', 'siteid': '14', 'gstno': 'KJ768768768', 'premiseno': '14', 'city': 'Bhgalpur', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 20, 'premisename': '14'}, 'creation_time': {'$date': 1553346530750}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '23467', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Tamil nadu SGST@9%+CGST@9%', 'total': 765234, 'accountno': 'XDN006114', 'pin': 341, 'circuitid': 'MLKKHKGSFHSFGLKSFJLG', 'invoicedate': '15-03-2019', 'invoiceno': '6767674', 'siteid': '341', 'gstno': '776GHHKJHLKJ;', 'premiseno': '341', 'city': 'Calicut', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 21, 'premisename': '341'}, 'creation_time': {'$date': 1553346530766}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '1223456', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '7 Mbps', 'division': 'DIVISON1', 'taxname': 'Tamil nadu SGST@9%+CGST@9%', 'total': 34565, 'accountno': 'XDN007146', 'pin': 13434, 'circuitid': 'NJJHHJJHHJLHKH', 'invoicedate': '15-03-2019', 'invoiceno': '55635635635', 'siteid': '13434', 'gstno': 'HIJH6', 'premiseno': '13434', 'city': 'Calicut', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 22, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530792}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '12345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '39, Poonam Society, Chandpole Kanpur - 501920', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '2 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 2345654, 'accountno': 'XDN080776', 'pin': 4314, 'circuitid': 'HHJH686765765765', 'invoicedate': '15-03-2019', 'invoiceno': '65265653', 'siteid': '4314', 'gstno': '36AAACI5950L1ZB', 'premiseno': '4314', 'city': 'Hariyana', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 23, 'premisename': '4314'}, 'creation_time': {'$date': 1553346530798}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'TL', 'arc': '7654', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '58, Deccan Gymkhana, Hisar - 483009', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '6 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 987, 'accountno': 'XDN080776', 'pin': 4134, 'circuitid': '765GKJHJKJLKJ', 'invoicedate': '15-03-2019', 'invoiceno': '656565', 'siteid': '4134', 'gstno': '36AAACI5950L1ZB', 'premiseno': '4134', 'city': 'Hariyana', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 23, 'premisename': '4134'}, 'creation_time': {'$date': 1553346530809}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'WB', 'arc': '1345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 924\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '8 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 4784578, 'accountno': 'XDN080776', 'pin': 14, 'circuitid': '78576NLMLKL;KK', 'invoicedate': '15-03-2019', 'invoiceno': '524656535', 'siteid': '14', 'gstno': '36AAACI5950L1ZB', 'premiseno': '14', 'city': 'Hariyana', 'tsp': 'TATA', 'customername': 'ABC Limited', 'slno': 23, 'premisename': '14'}, 'creation_time': {'$date': 1553346530813}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 0, 'xldata': {'state': 'LL', 'arc': '12345', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': '8064 Brewerton Rd, Cicero NY 13039', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 65, 'accountno': 'XDN118720', 'pin': 341, 'circuitid': 'JJHTTRUY56586', 'invoicedate': '15-03-2019', 'invoiceno': '452748796', 'siteid': '341', 'gstno': 'HKJJHH79879798', 'premiseno': '341', 'city': 'Hariyana', 'tsp': 'AIRTEL', 'customername': 'ABC Limited', 'slno': 24, 'premisename': '341'}, 'creation_time': {'$date': 1553346530817}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'initialUpload'}, 'older_history': [], 'last_doc': None}, {'current_doc': {'revnum': 1, 'xldata': {'state': 'HY', 'arc': '76543', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 9244\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 1234, 'accountno': 'XDN118720', 'pin': 13434, 'circuitid': 'NKJHHHS', 'invoicedate': '15-03-2019', 'invoiceno': '769680', 'siteid': '13434', 'gstno': '78979HJJLKJ', 'premiseno': '13434', 'city': 'Hariyana', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 24, 'premisename': '13434'}, 'creation_time': {'$date': 1553348097327}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553348096173}, 'logged_in_user_org_unit': 'ou1', 'requestid': '247abde3-3990-4979-8643-cd1cd2f5f226'}, 'status': 'ChangedByTSP'}, 'older_history': [], 'last_doc': {'revnum': 0, 'xldata': {'state': 'HY', 'arc': '76543', 'billingdateto': '01-03-2019', 'remarks': 'OK', 'fullsiteaddress': ' XYZ Example Exports\n Post Office Box 924\n Ludhiana 141003\n INDIA', 'customerid': 'XI000555', 'servicetype': 'GXDN', 'billingdatefrom': '02-04-2018', 'speed': '3 Mbps', 'division': 'DIVISON1', 'taxname': 'Telangana SGST@9%+CGST@9%', 'total': 1234, 'accountno': 'XDN118720', 'pin': 13434, 'circuitid': 'NKJHHHS', 'invoicedate': '15-03-2019', 'invoiceno': '769680', 'siteid': '13434', 'gstno': '78979HJJLKJ', 'premiseno': '13434', 'city': 'Hariyana', 'tsp': 'RIL', 'customername': 'ABC Limited', 'slno': 24, 'premisename': '13434'}, 'creation_time': {'$date': 1553346530823}, 'auditinfo': {'logged_in_user_dept': 'dept1', 'client_address': '127.0.0.1', 'logged_in_user_org': 'org1', 'logged_in_user_email': 'user1', 'api_call_time_stamp': {'$date': 1553346530495}, 'logged_in_user_org_unit': 'ou1', 'requestid': 'c275a5d7-60b3-4fea-a307-2b4078164e09'}, 'status': 'archived'}}
]
l = '/mydev/microservice-tsp-billing/micros1/micros1/tests/testdata/sample_inv_upload.xlsx'
p = 'C:\mydev\microservice-tsp-billing\micros1\micros1\tests\testdata\sample_inv_upload.xlsx'
from pathlib import Path
P = Path(p)
L = Path(l)
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
micros2client-1.tar.gz
(26.1 kB
view hashes)
