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 :
- get the correct public key
- To register your username
- To assign a role
- 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
- 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', '')
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:
-
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.
-
TSP can view adn update only their invoices , however this restriction is not there for user='user1'
-
Changes will be compared with the last invoice and no modification will be done unless any changes are detected
-
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')
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()
c.upload_xl('/mnt/c/mydev/temp/mxl2accept.xlsx')
c.recommend_changes_xl('/mnt/c/mydev/temp/mxl2accept.xlsx')
c.update_invoice_xl('/mnt/c/mydev/temp/mxl2accept.xlsx')
c.accept_recom_xl('/mnt/c/mydev/temp/mxl2accept.xlsx')
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', }
c.recommend_changes(listdata) c.update_invoice(listdata)
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'}}
]