{"@odata.context":"$metadata#Cases","value":[{"ID":"0f3bce03-5d2f-4ea5-87a9-23a70a36b1a5","city":"Bangalore","email":"Santoshktest@gmail.com","amount":null,"caseNo":"MCLV-2026-0F3BCE03","graded":null,"mobile":"345456456678","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-13T10:33:24.625Z","createdBy":"anonymous","createdOn":"2026-08-13","agencyName":null,"modifiedAt":"2026-08-13T10:33:24.625Z","modifiedBy":"anonymous","passportNo":"7698091JH","visaNumber":null,"arrivalDate":null,"candidateId":"506","companyCode":"1000","createdAtTs":null,"currentStep":1,"legalEntity":null,"nationality":"Saudi Arabia","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"529","arrivalStatus":null,"candidateName":"Santosh K","dateOfPayment":null,"medicalStatus":null,"requisitionId":"550","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"Saudi Arabia","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null},{"ID":"2c5c1716-5af5-4ce1-bebc-dbed581dd602","city":"Riyadh","email":"moin@gmail.com","amount":null,"caseNo":"MCLV-2026-2C5C1716","graded":null,"mobile":"8976324513","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-27T17:31:16.069Z","createdBy":"anonymous","createdOn":"2026-08-27","agencyName":null,"modifiedAt":"2026-08-27T17:31:16.069Z","modifiedBy":"anonymous","passportNo":"V2234567","visaNumber":null,"arrivalDate":null,"candidateId":"505","companyCode":"2000","createdAtTs":"2026-08-27T17:31:16.073Z","currentStep":1,"legalEntity":null,"nationality":"Saudi Arabia","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"524","arrivalStatus":null,"candidateName":"Moin A","dateOfPayment":null,"medicalStatus":null,"requisitionId":"531","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"Saudi Arabia","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null},{"ID":"50942d71-9dce-4517-9b9f-c93e28c11f14","city":"Riyadh","email":"naveen.kumar@example.com","amount":1245,"caseNo":"MCLV-2026-50942D71","graded":"Graded","mobile":"+966553331001","status":"Completed","country":"Saudi Arabia","comments":"ok","visaType":"Work Visa","createdAt":"2026-08-14T04:11:36.238Z","createdBy":"anonymous","createdOn":"2026-08-14","agencyName":"AASTHA","modifiedAt":"2026-08-14T05:26:59.614Z","modifiedBy":"privileged","passportNo":"CL1001001","visaNumber":"CL-VISA-1002","arrivalDate":"2026-08-14","candidateId":"MCLV-C1188","companyCode":"JAL11","createdAtTs":null,"currentStep":10,"legalEntity":null,"nationality":"Indian","shareStatus":"Shared","currentOwner":"System","currentStage":"Completed","shareEmailCc":null,"shareEmailTo":"test@admin.com","stampingDate":"2026-08-14","stampingFile":"Certificate.pdf","visaQuantity":"1","alignmentWith":"Department","applicationId":"MCLV-APP1001","arrivalStatus":"Arrived","candidateName":"Naveen Kumar","dateOfPayment":"2026-08-14","medicalStatus":"Pass","requisitionId":"MCLV-REQ5001","visaIssueDate":"2026-08-14","professionCode":"DW-CL-101","professionName":"Domestic Worker","shareEmailBody":"Dear Sir/Madam,\n\nWe are pleased to share the e-wakala details with you. Please review the information below.\n\nE-Wakala Request No.        : frdtgr65654tg5645\nE-Wakala Delegation No.     : fyhr6t76uhjf7\nE-Wakala Issue Date         : 2026-08-19\nVisa Type                   : Work Visa\nNationality                 : Indian\nSponsor ID                  : CL-SP-1002\nSponsor Name                : Al Noor Client Office\nVisa Issue Date             : 2026-08-14\nVisa Issue Number           : CL-VISA-1002\nCompany Code                : JAL11\nClient / Department         : Client Services\nVisa Profession Name        : Domestic Worker\nVisa Quantity               : 1\nAmount (SAR)                : 1245\nDate of Payment             : 2026-08-14\nAgency Name (Finalised)     : ALLIED\n\nPlease do not hesitate to contact us if you require any further information.\n\nBest regards,\nVisa Processing Team","stampingStatus":"Stamped","ticketFileName":"Certificate.pdf","visaProfession":"Housekeeping Attendant","airTicketStatus":"Arrived","arrivalComments":"ok","borderEntryDate":"2026-08-14","cashAdvanceFile":"Certificate.pdf","clientSponsorId":"CL-SP-1002","creditCardLast4":"5644","deportationDate":null,"deptConfirmDate":"2026-08-14","deptConfirmedBy":"Harry","medicalExamDate":"2026-08-14","undertakingDate":"2026-08-14T05:20:03.098Z","visaNationality":"Indian","visaProcessType":"Musaned Contract - Client Visa","departmentClient":"Client Services","eWakalaIssueDate":"2026-08-19","eWakalaRequestNo":"frdtgr65654tg5645","ticketProvidedBy":"Agency","agencyConfirmDate":"2026-08-14","agencyConfirmedBy":"Tom","cashAdvanceAmount":131,"clientAddressCity":"Jeddah","clientSponsorName":"Al Noor Client Office","deptConfirmStatus":"Confirmed","medicalReportFile":"Certificate.pdf","shareEmailSubject":"E-wakala Shared – frdtgr65654tg5645","undertakingStatus":"Signed","clientContractFile":"Certificate.pdf","clientMobileNumber":"+966500001002","agencyConfirmStatus":"Confirmed","agencyNameFinalised":"ALLIED","cashAdvanceCurrency":"SAR","clientOfficeAddress":"King Road, Jeddah","eWakalaDelegationNo":"fyhr6t76uhjf7","clientContractNumber":"MUS-CL-1002","undertakingSignature":"tom","deportationReferenceFile":null},{"ID":"5a2ffe65-14fd-4f8f-a4b3-74f90c09f20d","city":"Bangalore","email":"Santoshktest@gmail.com","amount":null,"caseNo":"MCLV-2026-5A2FFE65","graded":null,"mobile":"345456456678","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-13T10:12:07.095Z","createdBy":"anonymous","createdOn":"2026-08-13","agencyName":null,"modifiedAt":"2026-08-13T10:12:07.095Z","modifiedBy":"anonymous","passportNo":"7698091JH","visaNumber":null,"arrivalDate":null,"candidateId":"506","companyCode":"1000","createdAtTs":null,"currentStep":1,"legalEntity":null,"nationality":"Saudi Arabia","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"529","arrivalStatus":null,"candidateName":"Santosh K","dateOfPayment":null,"medicalStatus":null,"requisitionId":"550","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"Saudi Arabia","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null},{"ID":"690d00d3-dc66-4c28-8895-deff3a007492","city":"Bangalore","email":"Santoshktest@gmail.com","amount":null,"caseNo":"MCLV-2026-690D00D3","graded":null,"mobile":"345456456678","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-13T10:33:30.504Z","createdBy":"anonymous","createdOn":"2026-08-13","agencyName":null,"modifiedAt":"2026-08-13T10:33:30.504Z","modifiedBy":"anonymous","passportNo":"7698091JH","visaNumber":null,"arrivalDate":null,"candidateId":"506","companyCode":"1000","createdAtTs":null,"currentStep":1,"legalEntity":null,"nationality":"Saudi Arabia","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"529","arrivalStatus":null,"candidateName":"Santosh K","dateOfPayment":null,"medicalStatus":null,"requisitionId":"550","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"Saudi Arabia","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null},{"ID":"8d338a0c-08d6-4ae9-8359-b6112cf3defc","city":"Bangalore","email":"Santoshktest@gmail.com","amount":null,"caseNo":"MCLV-2026-8D338A0C","graded":null,"mobile":"345456456678","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-13T10:24:14.465Z","createdBy":"anonymous","createdOn":"2026-08-13","agencyName":null,"modifiedAt":"2026-08-13T10:24:14.465Z","modifiedBy":"anonymous","passportNo":"7698091JH","visaNumber":null,"arrivalDate":null,"candidateId":"506","companyCode":"1000","createdAtTs":null,"currentStep":1,"legalEntity":null,"nationality":"Saudi Arabia","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"529","arrivalStatus":null,"candidateName":"Santosh K","dateOfPayment":null,"medicalStatus":null,"requisitionId":"550","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"Saudi Arabia","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null},{"ID":"91bf4004-68ef-4f84-a990-498dd83a28e7","city":"Bangalore","email":"Santoshktest@gmail.com","amount":null,"caseNo":"MCLV-2026-91BF4004","graded":null,"mobile":"345456456678","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-13T10:14:58.527Z","createdBy":"anonymous","createdOn":"2026-08-13","agencyName":null,"modifiedAt":"2026-08-13T10:14:58.527Z","modifiedBy":"anonymous","passportNo":"7698091JH","visaNumber":null,"arrivalDate":null,"candidateId":"506","companyCode":"1000","createdAtTs":null,"currentStep":1,"legalEntity":null,"nationality":"Saudi Arabia","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"529","arrivalStatus":null,"candidateName":"Santosh K","dateOfPayment":null,"medicalStatus":null,"requisitionId":"550","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"Saudi Arabia","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null},{"ID":"dc3c409d-5e6e-48ac-be9d-bbb2bd6fc506","city":"Bangalore","email":"Santoshktest@gmail.com","amount":null,"caseNo":"MCLV-2026-DC3C409D","graded":null,"mobile":"345456456678","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-13T10:17:15.849Z","createdBy":"anonymous","createdOn":"2026-08-13","agencyName":null,"modifiedAt":"2026-08-13T10:17:15.849Z","modifiedBy":"anonymous","passportNo":"7698091JH","visaNumber":null,"arrivalDate":null,"candidateId":"506","companyCode":"1000","createdAtTs":null,"currentStep":1,"legalEntity":null,"nationality":"Saudi Arabia","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"529","arrivalStatus":null,"candidateName":"Santosh K","dateOfPayment":null,"medicalStatus":null,"requisitionId":"550","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"Saudi Arabia","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null},{"ID":"f6a5dc98-6ec3-49f3-9973-055af021a84b","city":"Delhi","email":"jawed@gmail.com","amount":null,"caseNo":"MCLV-2026-F6A5DC98","graded":"Graded","mobile":"8976324513","status":"Pending","country":"India","comments":null,"visaType":null,"createdAt":"2026-08-31T06:07:39.030Z","createdBy":"anonymous","createdOn":"2026-08-31","agencyName":null,"modifiedAt":"2026-08-31T06:07:39.030Z","modifiedBy":"anonymous","passportNo":"1234","visaNumber":null,"arrivalDate":null,"candidateId":"509","companyCode":"2000","createdAtTs":"2026-08-31T06:07:39.039Z","currentStep":1,"legalEntity":null,"nationality":"India","shareStatus":null,"currentOwner":"Recruiter","currentStage":"Visa Type Alignment","shareEmailCc":null,"shareEmailTo":null,"stampingDate":null,"stampingFile":null,"visaQuantity":null,"alignmentWith":null,"applicationId":"530","arrivalStatus":null,"candidateName":"Jawed Khan","dateOfPayment":null,"medicalStatus":null,"requisitionId":"532","visaIssueDate":null,"professionCode":null,"professionName":null,"shareEmailBody":null,"stampingStatus":null,"ticketFileName":null,"visaProfession":null,"airTicketStatus":null,"arrivalComments":null,"borderEntryDate":null,"cashAdvanceFile":null,"clientSponsorId":null,"creditCardLast4":null,"deportationDate":null,"deptConfirmDate":null,"deptConfirmedBy":null,"medicalExamDate":null,"undertakingDate":null,"visaNationality":"India","visaProcessType":null,"departmentClient":null,"eWakalaIssueDate":null,"eWakalaRequestNo":null,"ticketProvidedBy":null,"agencyConfirmDate":null,"agencyConfirmedBy":null,"cashAdvanceAmount":null,"clientAddressCity":null,"clientSponsorName":null,"deptConfirmStatus":null,"medicalReportFile":null,"shareEmailSubject":null,"undertakingStatus":null,"clientContractFile":null,"clientMobileNumber":null,"agencyConfirmStatus":null,"agencyNameFinalised":null,"cashAdvanceCurrency":null,"clientOfficeAddress":null,"eWakalaDelegationNo":null,"clientContractNumber":null,"undertakingSignature":null,"deportationReferenceFile":null}]}