Metadata-Version: 1.0
Name: micros1client
Version: 1.4
Summary: python and cli Client for providing  access to micros1 microservice after authtication from tokenleader
Home-page: https://github.com/microservice-tsp-billing/micros1-client
Author: Bhujay Kumar Bhatta
Author-email: bhujay.bhatta@yahoo.com
License: Apache Software License
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.upload_excel
          - micros1.list_all
          - micros1.delete_all
          - micros1.update_invoice
          - micros1.recommend_change
        
        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(('/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')
        	
        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/mxl2.xlsx')
        c.list_invoices_clo('City', 'Nagpur')
        c.list_invoices_clo('all', 'all')
        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 inout 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': '44444444444', 
                        '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': 'taxname', 'Total': 100, 'ServiceType': 'MPLS',
                        'City': 'city', 'State': 'state', 'PIN': 12345, 'PremiseNo': 'premno',
                        'PremiseName': 'premname', 'SiteID': 'siteid',
                        'FullSiteAddress': 'fullsiteaddrress',  'REMARKS': 'remarks',
                        }
        listdata = [test_xl_dict, ]
        c.recommend_changes(listdata)
        
        
        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'}}
        		
        	]
        	
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
Platform: UNKNOWN
