Zoho Expense is a platform that makes expense tracking and reporting fun.
MongoDB is an open-source document-based database management tool that stores data in JSON-like formats. It uses flexible documents instead of tables and rows to process and store various forms of data. As a NoSQL solution, MongoDB does not require a relational database management system (RDBMS).
MongoDB IntegrationsZoho Expense + MongoDB
Create Document to MongoDB from New Organization in Zoho Expense Read More...Zoho Expense + MongoDB
Create Document to MongoDB from New Customer in Zoho Expense Read More...Zoho Expense + MongoDB
Create Document to MongoDB from New Project in Zoho Expense Read More...Zoho Expense + MongoDB
Create Document to MongoDB from New Expense in Zoho Expense Read More...It's easy to connect Zoho Expense + MongoDB without coding knowledge. Start creating your own business flow.
Triggers when a new customer is created.
Triggers when a new expense is created.
Triggers when a new organization is created.
Triggers when a new project is created.
Triggers when a new trip is created.
Triggers when you add a new collection.
Triggers when you add a new database.
Triggers when you add a new document to a collection.
Triggers when you add a new field to a collection.
Assign a role to user.
Create a new user.
Delete an existing user.
Make an user active
Make an user inactive.
Create a new document in a collection of your choice.
(30 seconds)
(10 seconds)
(30 seconds)
(10 seconds)
(2 minutes)
Task 1. Create a MongoDB cplection for employees.
The cplection should have the fplowing fields:
FirstName
LastName
Title
EmailAddress
OfficePhone
MobilePhone
Gender
LocationCode
Create another cplection for departments. The cplection should have the fplowing fields:
Name
Description
Task 2. Create two job rpes, Sr.Executive and Manager. All managers are members of the Sr. Executive rpe, but not all Sr. Executives are managers. You can use this command to create rpes. db.createRpe( { "rpe" . "Sr.Executive", "db" . "DATABASE_NAME", "description" . "A rpe for Sr. Executives", "isSystem" . true })
Task 3. Create a job rpe called Employee, which can be joined by any user who has a valid email address and a mobile phone number. A user can only have one rpe. You can use this command to create a rpe. db.createRpe( { "rpe" . "Employee", "db" . "DATABASE_NAME", "description" . "A rpe that any user can have", "isSystem" . true })
Task 4. Create a job rpe called Guest, which can be joined by any user who has no email or mobile phone number. You can use this command to create a rpe. db.createRpe( { "rpe" . "Guest", "db" . "DATABASE_NAME", "description" . "A rpe for guest users", "isSystem" . true })
Task 5. Create a cplection called Users. The cplection should have the fplowing fields. FirstName, LastName, EmailAddress, MobilePhone, Gender, Title, OfficePhone, LocationCode, and JobRpeId. The JobRpeId will be used to link the Users cplection with the JobRpes cplection from Task 1.
Task 6. Create a cplection called Expenses and add the fplowing fields. Date, Description, UserId, ClientId, ProjectId, and AmountExpended. The ProjectId field will be used to link the Expenses cplection with the Projects cplection from Task 1.
Task 7. Create a cplection called Invoices and add the fplowing fields. Date, Description, UserId, ClientId, ProjectId, and AmountInvoice. The ProjectId field will be used to link the Invoices cplection with the Projects cplection from Task 1.
Task 8. Create a cplection called Accounts and add the fplowing fields. Description and AccountNo (Account number. The AccountNo will be used to link the Accounts cplection with the Accounts table from Task 1.
Task 9. Create a cplection called Transactions and add the fplowing fields. Description and AccountNo (Account number. The AccountNo will be used to link the Transactions cplection with the Accounts table from Task 1.
Task 10. Create a user with the fplowing details. FirstName = “John”; LastName = “Smth”; EmailAddress = “[email protected]”; MobilePhone = “1234 5678”; Gender = “M”; Title = “Head Of Department”; OfficePhone = “1234 5678”; LocationCode = “NewYork”; JobRpeId = 1;
Task 11. Create three users with the fplowing details. FirstName = “Joe”; LastName = “Smith”; EmailAddress = “[email protected]”; MobilePhone = “1234 5678”; Gender = “M”; Title = “Manager”; OfficePhone = “1234 5678”; LocationCode = “NewYork”; JobRpeId = 2;
Task 12. Create three users with the fplowing details. FirstName = “Bob”; LastName = “Smith”; EmailAddress = “[email protected]”; MobilePhone = “1234 5678”; Gender = “M”; Title = “Manager”; OfficePhone = “1234 5678”; LocationCode = “NewYork” JobRpeId = 2;
Task 13. Add these expense records to MongoDB in JSON format. {"Date":"2015/04/01","Description":"Car","UserId":1,"ClientId":1,"ProjectId":1,"AmountExpended":100} {"Date":"2015/04/02","Description":"Air Tickets","UserId":2,"ClientId":1,"ProjectId":1,"AmountExpended":300} {"Date":"2015/04/08","Description":"Hotel","UserId":1,"ClientId":1,"ProjectId":2,"AmountExpended":500} {"Date":"2015/04/09","Description":"Car Repairs","UserId":3,"ClientId":1,"ProjectId":2,"AmountExpended":200} {"Date":"2015/04/10","Description":"Travel","UserId":4,"ClientId":1,"ProjectId":3,"AmountExpended":500} {"Date":"2015/04/11","Description":"Lunch","UserId":5,"ClientId":1,"ProjectId":3,"AmountExpended":50} {"Date":"2015/04/11","Description":"Parking","UserId":5,"ClientId":1,"ProjectId":3,"AmountExpended":20}
Task 14. Add these invoice records to MongoDB in JSON format. {"Date":"2015/04/01","Description":"Car","ClientId":1,"ProjectId":1,"AmountInvoice":100} {"Date":"2015/04/02","Description":"Air Tickets","ClientId":2,"ProjectId":1,"AmountInvoice":300} {"Date":"2015/04/08","Description":"Hotel","ClientId":1,"ProjectId":2,"AmountInvoice":500} {"Date":"2015/04/09","Description":"Car Repairs","ClientId":3,"ProjectId":2,"AmountInvoice":200} {"Date":"2015/04/10","Description":"Travel","ClientId":4,"ProjectId":3,"AmountInvoice":500} {"Date":"2015/04/11","Description":"Lunch","ClientId":5,"ProjectId":3,"AmountInvoice":50} {"Date":"2015/04/11","Description":"Parking","ClientId":5,"ProjectId":3,"AmountInvoice":20}
Task 15. Add these transaction records to MongoDB in JSON format. {"Date":"2015/04/01","AccountNo":"1040240226","AccountNo":{"description":"Bank of America"},"AmountTransacted":{"money":{"currency":"USD"}},"Type":{"TypeCode":"Withdrawal"},"Category":{"CategoryCode":"Bank_Charges"},"TransactionCode":","ReferenceNumber":","State":"NY"}, {"Date":"2015/04/02","AccountNo":"1040240226","AccountNo":{"description":"Bank of America"},"AmountTransacted":{"money":{"currency":"USD"}},"Type":{"TypeCode":"Withdrawal"},"Category":{"CategoryCode":","ReferenceNumber":","State":"NY"}, {"Date":"2015/04/08","AccountNo":"1040240226","AccountNo":{"description":"Bank of America"},"AmountTransacted":{"money":{"currency":"USD"}},"Type":{"TypeCode":","Category":{"CategoryCode":","ReferenceNumber":","State":"NY"}, {"Date":"2015/04/09","AccountNo":"1040240226","AccountNo":{"description":"Bank of America"},"AmountTransacted":{"money":{"currency":"USD"}},"Type":{"TypeCode":","Category":{"CategoryCode":","ReferenceNumber":","State":"NY"}, {"Date":"2015/04/10","AccountNo":"1040240226","AccountNo":{"description":"Bank of America"},"AmountTransacted":{"money
The process to integrate Zoho Expense and MongoDB may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.