Employee Advances
AI Tools
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
An employee advance entity allows you to manage advance payments made to employees.
Attribute
draft, submitted, approved, rejected, recalled, void.applied, unapplied.yyyy-MM-dd format.true and false.{
"advance_payment_id": "16367000000243203",
"currency_id": "16367000000000099",
"currency_code": "USD",
"rcy_currency_id": "16367000000000099",
"rcy_currency_code": "USD",
"refund_currency_id": "16367000000000099",
"account_id": "16367000000036003",
"account_name": "Petty Cash",
"to_account_id": "16367000000036007",
"to_account_name": "Employee Advance",
"reference_number": "ADV-00001",
"notes": "Advance for business trip to New York.",
"refund_notes": "Refund credited to petty cash.",
"refund_reference_number": "REF-00001",
"status": "approved",
"sub_status": "",
"advance_status": "unapplied",
"exchange_rate": 1,
"rcy_exchange_rate": 1,
"refund_exchange_rate": 1,
"amount": 5000,
"bcy_amount": 5000,
"rcy_amount": 5000,
"refund_amount": 5000,
"refund_bcy_amount": 5000,
"refund_rcy_amount": 5000,
"date": "2024-01-15",
"refund_date": "2024-01-30",
"price_precision": 2,
"created_time": "2024-01-15T10:30:00+0530",
"created_date": "2024-01-15",
"last_modified_time": "2024-01-15T12:00:00+0530",
"user_id": "16367000000073001",
"user_name": "Will Smith",
"user_email": "will.smith@zillum.com",
"user_zuid": "12345678",
"user_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"employee_no": "E001",
"department_name": "Finance",
"policy_id": "16367000000092011",
"policy_name": "Default Policy",
"created_by": "Will Smith",
"created_by_id": "16367000000073071",
"created_by_name": "Will Smith",
"created_by_email": "will.smith@zillum.com",
"created_by_employee_no": "E002",
"creator_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"submitted_date": "2024-01-16",
"last_submitted_date": "2024-01-16",
"approved_date": "2024-01-17",
"approver_id": "16367000000073001",
"approver_name": "PATRICIA BOYLE",
"approver_email": "patriciab@zillum.com",
"approver_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"approver_employee_no": "E001",
"approver_zuid": "23456789",
"submitted_to_id": "16367000000073001",
"submitted_to_name": "PATRICIA BOYLE",
"submitted_to_email": "patriciab@zillum.com",
"submitted_to_employee_no": "E001",
"customer_id": "16367000000088005",
"customer_name": "Zillum Corp",
"project_id": "16367000000223045",
"project_name": "Brochure Design",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"report_number": "ER-00001",
"report_status": "approved",
"trip_id": "16367000000312001",
"trip_number": "TR-00001",
"trip_name": "Business trip to New York",
"trip_status": "approved",
"is_carried_forward_advance": false,
"reference_report_id": "16367000000081005",
"refund_recorded_by": "Will Smith",
"refund_recorded_by_id": "16367000000073071",
"location_id": "16367000000401005",
"documents": [
{
"document_id": "16367000000078085",
"file_name": "receipt.pdf",
"file_size_formatted": "45.2 KB",
"attachment_order": 1
}
],
"expense_reports": [
{
"reimbursement_entity_id": "16367000000501001",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"amount": 3000,
"date": "2024-01-20",
"report_number": "ER-00001",
"report_status": "approved"
}
],
"comments": [
{
"comment_id": "16367000000601001",
"advance_id": "16367000000243203",
"commented_by": "PATRICIA BOYLE",
"commented_by_id": "16367000000073001",
"date": "2024-01-17",
"type": "comment",
"previous_status": "submitted",
"approval_status": "approved"
}
],
"custom_fields": [
{
"customfield_id": "16367000000277001",
"label": "Department Code",
"value": "FIN-001"
}
]
}
Create an advance payment
AI Tools
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Create a new advance payment for an employee. The currency_id, amount, date, and user_id fields are required.
OAuth Scope : ZohoExpense.advance.CREATE
Arguments
yyyy-MM-dd format.Query Parameters
Headers
parameters_data='{"field1":"value1","field2":"value2"}';
headers_data = Map();
headers_data.put("X-com-zoho-expense-organizationid", "10234695");
headers_data.put("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f");
response = invokeUrl
[
url: "https://www.zohoapis.com/expense/v1/advancepayments"
type: POST
headers: headers_data
content-type: application/json
parameters: parameters_data
connection: <connection_name>
];
info response;
OkHttpClient client = new OkHttpClient();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{\"field1\":\"value1\",\"field2\":\"value2\"}");
Request request = new Request.Builder()
.url("https://www.zohoapis.com/expense/v1/advancepayments")
.post(body)
.addHeader("X-com-zoho-expense-organizationid", "10234695")
.addHeader("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f")
.addHeader("content-type", "application/json")
.build();
Response response = client.newCall(request).execute();
const options = {
method: 'POST',
headers: {
'X-com-zoho-expense-organizationid': '10234695',
Authorization: 'Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f',
'content-type': 'application/json'
},
body: '{"field1":"value1","field2":"value2"}'
};
fetch('https://www.zohoapis.com/expense/v1/advancepayments', options)
.then(response => response.json())
.then(response => console.log(response))
.catch(err => console.error(err));
import http.client
conn = http.client.HTTPSConnection("www.zohoapis.com")
payload = "{\"field1\":\"value1\",\"field2\":\"value2\"}"
headers = {
'X-com-zoho-expense-organizationid': "10234695",
'Authorization': "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f",
'content-type': "application/json"
}
conn.request("POST", "/expense/v1/advancepayments", payload, headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))
const http = require("https");
const options = {
"method": "POST",
"hostname": "www.zohoapis.com",
"port": null,
"path": "/expense/v1/advancepayments",
"headers": {
"X-com-zoho-expense-organizationid": "10234695",
"Authorization": "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f",
"content-type": "application/json"
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on("data", function (chunk) {
chunks.push(chunk);
});
res.on("end", function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.write(JSON.stringify({field1: 'value1', field2: 'value2'}));
req.end();
curl --request POST \
--url https://www.zohoapis.com/expense/v1/advancepayments \
--header 'Authorization: Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f' \
--header 'X-com-zoho-expense-organizationid: 10234695' \
--header 'content-type: application/json' \
--data '{"field1":"value1","field2":"value2"}'
{
"date": "2024-02-15",
"amount": 5000,
"exchange_rate": 1,
"rcy_exchange_rate": 1,
"notes": "Travel advance for client visit.",
"reference_number": "ADV-00001",
"currency_id": "16367000000000099",
"account_id": "16367000000036003",
"user_id": "16367000000073001",
"trip_id": "34017000000000103",
"customer_id": "16367000000088005",
"project_id": "16367000000223045",
"location_id": "16367000000110001",
"custom_fields": [
{
"customfield_id": "16367000000277001",
"value": "FIN-001"
}
]
}
{
"code": 0,
"message": "Employee advance has been created successfully.",
"advance_payment": {
"advance_payment_id": "16367000000243203",
"currency_id": "16367000000000099",
"currency_code": "USD",
"rcy_currency_id": "16367000000000099",
"rcy_currency_code": "USD",
"refund_currency_id": "16367000000000099",
"account_id": "16367000000036003",
"account_name": "Petty Cash",
"to_account_id": "16367000000036007",
"to_account_name": "Employee Advance",
"reference_number": "ADV-00001",
"notes": "Advance for business trip to New York.",
"refund_notes": "Refund credited to petty cash.",
"refund_reference_number": "REF-00001",
"status": "approved",
"sub_status": "",
"advance_status": "unapplied",
"exchange_rate": 1,
"rcy_exchange_rate": 1,
"refund_exchange_rate": 1,
"amount": 5000,
"bcy_amount": 5000,
"rcy_amount": 5000,
"refund_amount": 5000,
"refund_bcy_amount": 5000,
"refund_rcy_amount": 5000,
"date": "2024-01-15",
"refund_date": "2024-01-30",
"price_precision": 2,
"created_time": "2024-01-15T10:30:00+0530",
"created_date": "2024-01-15",
"last_modified_time": "2024-01-15T12:00:00+0530",
"user_id": "16367000000073001",
"user_name": "Will Smith",
"user_email": "will.smith@zillum.com",
"user_zuid": "12345678",
"user_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"employee_no": "E001",
"department_name": "Finance",
"policy_id": "16367000000092011",
"policy_name": "Default Policy",
"created_by": "Will Smith",
"created_by_id": "16367000000073071",
"created_by_name": "Will Smith",
"created_by_email": "will.smith@zillum.com",
"created_by_employee_no": "E002",
"creator_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"submitted_date": "2024-01-16",
"last_submitted_date": "2024-01-16",
"approved_date": "2024-01-17",
"approver_id": "16367000000073001",
"approver_name": "PATRICIA BOYLE",
"approver_email": "patriciab@zillum.com",
"approver_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"approver_employee_no": "E001",
"approver_zuid": "23456789",
"submitted_to_id": "16367000000073001",
"submitted_to_name": "PATRICIA BOYLE",
"submitted_to_email": "patriciab@zillum.com",
"submitted_to_employee_no": "E001",
"customer_id": "16367000000088005",
"customer_name": "Zillum Corp",
"project_id": "16367000000223045",
"project_name": "Brochure Design",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"report_number": "ER-00001",
"report_status": "approved",
"trip_id": "16367000000312001",
"trip_number": "TR-00001",
"trip_name": "Business trip to New York",
"trip_status": "approved",
"is_carried_forward_advance": false,
"reference_report_id": "16367000000081005",
"refund_recorded_by": "Will Smith",
"refund_recorded_by_id": "16367000000073071",
"location_id": "16367000000401005",
"documents": [
{
"document_id": "16367000000078085",
"file_name": "receipt.pdf",
"file_size_formatted": "45.2 KB",
"attachment_order": 1
}
],
"expense_reports": [
{
"reimbursement_entity_id": "16367000000501001",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"amount": 3000,
"date": "2024-01-20",
"report_number": "ER-00001",
"report_status": "approved"
}
],
"comments": [
{
"comment_id": "16367000000601001",
"advance_id": "16367000000243203",
"commented_by": "PATRICIA BOYLE",
"commented_by_id": "16367000000073001",
"date": "2024-01-17",
"type": "comment",
"previous_status": "submitted",
"approval_status": "approved"
}
],
"custom_fields": [
{
"customfield_id": "16367000000277001",
"label": "Department Code",
"value": "FIN-001"
}
]
}
}
List advance payments
AI Tools
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
List all advance payments for the organization.
OAuth Scope : ZohoExpense.advance.READ
Query Parameters
Status.All, Status.Draft, Status.Submitted, Status.Approved, Status.UnApproved, Status.Rejected, Status.Unsubmitted, Status.ModifiableAdvances, Status.Void, Status.Exported, Status.Unexported, Type.All, Type.Approval, Type.Advance, Type.MyApproval, Type.SharedAdvance.all, submitted, draft, recalled, approved, unapproved, rejected, unsubmitted, modifiable, applied, unapplied, unrefunded, void. Multiple values can be combined with commas.approval, myapproval, advance.cash.exported, unexported.user_name, date, reference_number, created_by_name, amount, status, approver_name, customer_name, employee_no, account_name, project_name, report_number, report_name, submitted_date, last_submitted_date, trip_number.A for ascending, D for descending.Headers
headers_data = Map();
headers_data.put("X-com-zoho-expense-organizationid", "10234695");
headers_data.put("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f");
response = invokeUrl
[
url: "https://www.zohoapis.com/expense/v1/advancepayments"
type: GET
headers: headers_data
connection: <connection_name>
];
info response;
OkHttpClient client = new OkHttpClient();
Request request = new Request.Builder()
.url("https://www.zohoapis.com/expense/v1/advancepayments")
.get()
.addHeader("X-com-zoho-expense-organizationid", "10234695")
.addHeader("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f")
.build();
Response response = client.newCall(request).execute();
const options = {
method: 'GET',
headers: {
'X-com-zoho-expense-organizationid': '10234695',
Authorization: 'Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f'
}
};
fetch('https://www.zohoapis.com/expense/v1/advancepayments', options)
.then(response => response.json())
.then(response => console.log(response))
.catch(err => console.error(err));
import http.client
conn = http.client.HTTPSConnection("www.zohoapis.com")
headers = {
'X-com-zoho-expense-organizationid': "10234695",
'Authorization': "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f"
}
conn.request("GET", "/expense/v1/advancepayments", headers=headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))
const http = require("https");
const options = {
"method": "GET",
"hostname": "www.zohoapis.com",
"port": null,
"path": "/expense/v1/advancepayments",
"headers": {
"X-com-zoho-expense-organizationid": "10234695",
"Authorization": "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f"
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on("data", function (chunk) {
chunks.push(chunk);
});
res.on("end", function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.end();
curl --request GET \
--url https://www.zohoapis.com/expense/v1/advancepayments \
--header 'Authorization: Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f' \
--header 'X-com-zoho-expense-organizationid: 10234695'
{
"code": 0,
"message": "success",
"advance_payments": [
{
"advance_payment_id": "16367000000243203",
"currency_id": "16367000000000099",
"currency_code": "USD",
"rcy_currency_id": "16367000000000099",
"rcy_currency_code": "USD",
"refund_currency_id": "16367000000000099",
"account_id": "16367000000036003",
"account_name": "Petty Cash",
"to_account_id": "16367000000036007",
"to_account_name": "Employee Advance",
"reference_number": "ADV-00001",
"notes": "Advance for business trip to New York.",
"refund_notes": "Refund credited to petty cash.",
"refund_reference_number": "REF-00001",
"status": "approved",
"sub_status": "",
"advance_status": "unapplied",
"exchange_rate": 1,
"rcy_exchange_rate": 1,
"refund_exchange_rate": 1,
"amount": 5000,
"bcy_amount": 5000,
"rcy_amount": 5000,
"refund_amount": 5000,
"refund_bcy_amount": 5000,
"refund_rcy_amount": 5000,
"date": "2024-01-15",
"refund_date": "2024-01-30",
"price_precision": 2,
"created_time": "2024-01-15T10:30:00+0530",
"created_date": "2024-01-15",
"last_modified_time": "2024-01-15T12:00:00+0530",
"user_id": "16367000000073001",
"user_name": "Will Smith",
"user_email": "will.smith@zillum.com",
"user_zuid": "12345678",
"user_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"employee_no": "E001",
"department_name": "Finance",
"policy_id": "16367000000092011",
"policy_name": "Default Policy",
"created_by": "Will Smith",
"created_by_id": "16367000000073071",
"created_by_name": "Will Smith",
"created_by_email": "will.smith@zillum.com",
"created_by_employee_no": "E002",
"creator_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"submitted_date": "2024-01-16",
"last_submitted_date": "2024-01-16",
"approved_date": "2024-01-17",
"approver_id": "16367000000073001",
"approver_name": "PATRICIA BOYLE",
"approver_email": "patriciab@zillum.com",
"approver_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"approver_employee_no": "E001",
"approver_zuid": "23456789",
"submitted_to_id": "16367000000073001",
"submitted_to_name": "PATRICIA BOYLE",
"submitted_to_email": "patriciab@zillum.com",
"submitted_to_employee_no": "E001",
"customer_id": "16367000000088005",
"customer_name": "Zillum Corp",
"project_id": "16367000000223045",
"project_name": "Brochure Design",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"report_number": "ER-00001",
"report_status": "approved",
"trip_id": "16367000000312001",
"trip_number": "TR-00001",
"trip_name": "Business trip to New York",
"trip_status": "approved",
"is_carried_forward_advance": false,
"reference_report_id": "16367000000081005",
"refund_recorded_by": "Will Smith",
"refund_recorded_by_id": "16367000000073071",
"location_id": "16367000000401005",
"documents": [
{
"document_id": "16367000000078085",
"file_name": "receipt.pdf",
"file_size_formatted": "45.2 KB",
"attachment_order": 1
}
],
"expense_reports": [
{
"reimbursement_entity_id": "16367000000501001",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"amount": 3000,
"date": "2024-01-20",
"report_number": "ER-00001",
"report_status": "approved"
}
],
"comments": [
{
"comment_id": "16367000000601001",
"advance_id": "16367000000243203",
"commented_by": "PATRICIA BOYLE",
"commented_by_id": "16367000000073001",
"date": "2024-01-17",
"type": "comment",
"previous_status": "submitted",
"approval_status": "approved"
}
],
"custom_fields": [
{
"customfield_id": "16367000000277001",
"label": "Department Code",
"value": "FIN-001"
}
]
},
{...},
{...}
],
"page_context": {
"page": 1,
"per_page": 200,
"has_more_page": false,
"report_name": "Advance Payment Details",
"applied_filter": "Status.All",
"sort_column": "created_time",
"sort_order": "D"
}
}
Update an advance payment
AI Tools
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Update the details of an existing advance payment. Only draft advances can be edited.
OAuth Scope : ZohoExpense.advance.UPDATE
Path Parameters
Query Parameters
true and false.Headers
parameters_data='{"field1":"value1","field2":"value2"}';
headers_data = Map();
headers_data.put("X-com-zoho-expense-organizationid", "10234695");
headers_data.put("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f");
response = invokeUrl
[
url: "https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203"
type: PUT
headers: headers_data
content-type: application/json
parameters: parameters_data
connection: <connection_name>
];
info response;
OkHttpClient client = new OkHttpClient();
MediaType mediaType = MediaType.parse("application/json");
RequestBody body = RequestBody.create(mediaType, "{\"field1\":\"value1\",\"field2\":\"value2\"}");
Request request = new Request.Builder()
.url("https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203")
.put(body)
.addHeader("X-com-zoho-expense-organizationid", "10234695")
.addHeader("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f")
.addHeader("content-type", "application/json")
.build();
Response response = client.newCall(request).execute();
const options = {
method: 'PUT',
headers: {
'X-com-zoho-expense-organizationid': '10234695',
Authorization: 'Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f',
'content-type': 'application/json'
},
body: '{"field1":"value1","field2":"value2"}'
};
fetch('https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203', options)
.then(response => response.json())
.then(response => console.log(response))
.catch(err => console.error(err));
import http.client
conn = http.client.HTTPSConnection("www.zohoapis.com")
payload = "{\"field1\":\"value1\",\"field2\":\"value2\"}"
headers = {
'X-com-zoho-expense-organizationid': "10234695",
'Authorization': "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f",
'content-type': "application/json"
}
conn.request("PUT", "/expense/v1/advancepayments/16367000000243203", payload, headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))
const http = require("https");
const options = {
"method": "PUT",
"hostname": "www.zohoapis.com",
"port": null,
"path": "/expense/v1/advancepayments/16367000000243203",
"headers": {
"X-com-zoho-expense-organizationid": "10234695",
"Authorization": "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f",
"content-type": "application/json"
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on("data", function (chunk) {
chunks.push(chunk);
});
res.on("end", function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.write(JSON.stringify({field1: 'value1', field2: 'value2'}));
req.end();
curl --request PUT \
--url https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203 \
--header 'Authorization: Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f' \
--header 'X-com-zoho-expense-organizationid: 10234695' \
--header 'content-type: application/json' \
--data '{"field1":"value1","field2":"value2"}'
{
"date": "2024-02-15",
"amount": 5000,
"exchange_rate": 1,
"rcy_exchange_rate": 1,
"notes": "Travel advance for client visit.",
"reference_number": "ADV-00001",
"currency_id": "16367000000000099",
"account_id": "16367000000036003",
"user_id": "16367000000073001",
"trip_id": "34017000000000103",
"customer_id": "16367000000088005",
"project_id": "16367000000223045",
"location_id": "16367000000110001",
"custom_fields": [
{
"customfield_id": "16367000000277001",
"value": "FIN-001"
}
]
}
{
"code": 0,
"message": "Employee advance has been updated successfully.",
"advance_payment": {
"advance_payment_id": "16367000000243203",
"currency_id": "16367000000000099",
"currency_code": "USD",
"rcy_currency_id": "16367000000000099",
"rcy_currency_code": "USD",
"refund_currency_id": "16367000000000099",
"account_id": "16367000000036003",
"account_name": "Petty Cash",
"to_account_id": "16367000000036007",
"to_account_name": "Employee Advance",
"reference_number": "ADV-00001",
"notes": "Advance for business trip to New York.",
"refund_notes": "Refund credited to petty cash.",
"refund_reference_number": "REF-00001",
"status": "approved",
"sub_status": "",
"advance_status": "unapplied",
"exchange_rate": 1,
"rcy_exchange_rate": 1,
"refund_exchange_rate": 1,
"amount": 5000,
"bcy_amount": 5000,
"rcy_amount": 5000,
"refund_amount": 5000,
"refund_bcy_amount": 5000,
"refund_rcy_amount": 5000,
"date": "2024-01-15",
"refund_date": "2024-01-30",
"price_precision": 2,
"created_time": "2024-01-15T10:30:00+0530",
"created_date": "2024-01-15",
"last_modified_time": "2024-01-15T12:00:00+0530",
"user_id": "16367000000073001",
"user_name": "Will Smith",
"user_email": "will.smith@zillum.com",
"user_zuid": "12345678",
"user_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"employee_no": "E001",
"department_name": "Finance",
"policy_id": "16367000000092011",
"policy_name": "Default Policy",
"created_by": "Will Smith",
"created_by_id": "16367000000073071",
"created_by_name": "Will Smith",
"created_by_email": "will.smith@zillum.com",
"created_by_employee_no": "E002",
"creator_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"submitted_date": "2024-01-16",
"last_submitted_date": "2024-01-16",
"approved_date": "2024-01-17",
"approver_id": "16367000000073001",
"approver_name": "PATRICIA BOYLE",
"approver_email": "patriciab@zillum.com",
"approver_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"approver_employee_no": "E001",
"approver_zuid": "23456789",
"submitted_to_id": "16367000000073001",
"submitted_to_name": "PATRICIA BOYLE",
"submitted_to_email": "patriciab@zillum.com",
"submitted_to_employee_no": "E001",
"customer_id": "16367000000088005",
"customer_name": "Zillum Corp",
"project_id": "16367000000223045",
"project_name": "Brochure Design",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"report_number": "ER-00001",
"report_status": "approved",
"trip_id": "16367000000312001",
"trip_number": "TR-00001",
"trip_name": "Business trip to New York",
"trip_status": "approved",
"is_carried_forward_advance": false,
"reference_report_id": "16367000000081005",
"refund_recorded_by": "Will Smith",
"refund_recorded_by_id": "16367000000073071",
"location_id": "16367000000401005",
"documents": [
{
"document_id": "16367000000078085",
"file_name": "receipt.pdf",
"file_size_formatted": "45.2 KB",
"attachment_order": 1
}
],
"expense_reports": [
{
"reimbursement_entity_id": "16367000000501001",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"amount": 3000,
"date": "2024-01-20",
"report_number": "ER-00001",
"report_status": "approved"
}
],
"comments": [
{
"comment_id": "16367000000601001",
"advance_id": "16367000000243203",
"commented_by": "PATRICIA BOYLE",
"commented_by_id": "16367000000073001",
"date": "2024-01-17",
"type": "comment",
"previous_status": "submitted",
"approval_status": "approved"
}
],
"custom_fields": [
{
"customfield_id": "16367000000277001",
"label": "Department Code",
"value": "FIN-001"
}
]
}
}
Retrieve an advance payment
AI Tools
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Retrieve the details of an existing advance payment.
OAuth Scope : ZohoExpense.advance.READ
Path Parameters
Query Parameters
true and false.Headers
headers_data = Map();
headers_data.put("X-com-zoho-expense-organizationid", "10234695");
headers_data.put("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f");
response = invokeUrl
[
url: "https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203"
type: GET
headers: headers_data
connection: <connection_name>
];
info response;
OkHttpClient client = new OkHttpClient();
Request request = new Request.Builder()
.url("https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203")
.get()
.addHeader("X-com-zoho-expense-organizationid", "10234695")
.addHeader("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f")
.build();
Response response = client.newCall(request).execute();
const options = {
method: 'GET',
headers: {
'X-com-zoho-expense-organizationid': '10234695',
Authorization: 'Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f'
}
};
fetch('https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203', options)
.then(response => response.json())
.then(response => console.log(response))
.catch(err => console.error(err));
import http.client
conn = http.client.HTTPSConnection("www.zohoapis.com")
headers = {
'X-com-zoho-expense-organizationid': "10234695",
'Authorization': "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f"
}
conn.request("GET", "/expense/v1/advancepayments/16367000000243203", headers=headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))
const http = require("https");
const options = {
"method": "GET",
"hostname": "www.zohoapis.com",
"port": null,
"path": "/expense/v1/advancepayments/16367000000243203",
"headers": {
"X-com-zoho-expense-organizationid": "10234695",
"Authorization": "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f"
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on("data", function (chunk) {
chunks.push(chunk);
});
res.on("end", function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.end();
curl --request GET \
--url https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203 \
--header 'Authorization: Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f' \
--header 'X-com-zoho-expense-organizationid: 10234695'
{
"code": 0,
"message": "success",
"advance_payment": {
"advance_payment_id": "16367000000243203",
"currency_id": "16367000000000099",
"currency_code": "USD",
"rcy_currency_id": "16367000000000099",
"rcy_currency_code": "USD",
"refund_currency_id": "16367000000000099",
"account_id": "16367000000036003",
"account_name": "Petty Cash",
"to_account_id": "16367000000036007",
"to_account_name": "Employee Advance",
"reference_number": "ADV-00001",
"notes": "Advance for business trip to New York.",
"refund_notes": "Refund credited to petty cash.",
"refund_reference_number": "REF-00001",
"status": "approved",
"sub_status": "",
"advance_status": "unapplied",
"exchange_rate": 1,
"rcy_exchange_rate": 1,
"refund_exchange_rate": 1,
"amount": 5000,
"bcy_amount": 5000,
"rcy_amount": 5000,
"refund_amount": 5000,
"refund_bcy_amount": 5000,
"refund_rcy_amount": 5000,
"date": "2024-01-15",
"refund_date": "2024-01-30",
"price_precision": 2,
"created_time": "2024-01-15T10:30:00+0530",
"created_date": "2024-01-15",
"last_modified_time": "2024-01-15T12:00:00+0530",
"user_id": "16367000000073001",
"user_name": "Will Smith",
"user_email": "will.smith@zillum.com",
"user_zuid": "12345678",
"user_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"employee_no": "E001",
"department_name": "Finance",
"policy_id": "16367000000092011",
"policy_name": "Default Policy",
"created_by": "Will Smith",
"created_by_id": "16367000000073071",
"created_by_name": "Will Smith",
"created_by_email": "will.smith@zillum.com",
"created_by_employee_no": "E002",
"creator_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"submitted_date": "2024-01-16",
"last_submitted_date": "2024-01-16",
"approved_date": "2024-01-17",
"approver_id": "16367000000073001",
"approver_name": "PATRICIA BOYLE",
"approver_email": "patriciab@zillum.com",
"approver_photo_url": "https://contacts.zoho.com/file?ID=abc123&fs=thumb",
"approver_employee_no": "E001",
"approver_zuid": "23456789",
"submitted_to_id": "16367000000073001",
"submitted_to_name": "PATRICIA BOYLE",
"submitted_to_email": "patriciab@zillum.com",
"submitted_to_employee_no": "E001",
"customer_id": "16367000000088005",
"customer_name": "Zillum Corp",
"project_id": "16367000000223045",
"project_name": "Brochure Design",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"report_number": "ER-00001",
"report_status": "approved",
"trip_id": "16367000000312001",
"trip_number": "TR-00001",
"trip_name": "Business trip to New York",
"trip_status": "approved",
"is_carried_forward_advance": false,
"reference_report_id": "16367000000081005",
"refund_recorded_by": "Will Smith",
"refund_recorded_by_id": "16367000000073071",
"location_id": "16367000000401005",
"documents": [
{
"document_id": "16367000000078085",
"file_name": "receipt.pdf",
"file_size_formatted": "45.2 KB",
"attachment_order": 1
}
],
"expense_reports": [
{
"reimbursement_entity_id": "16367000000501001",
"report_id": "16367000000081005",
"report_name": "Trip to SFA",
"amount": 3000,
"date": "2024-01-20",
"report_number": "ER-00001",
"report_status": "approved"
}
],
"comments": [
{
"comment_id": "16367000000601001",
"advance_id": "16367000000243203",
"commented_by": "PATRICIA BOYLE",
"commented_by_id": "16367000000073001",
"date": "2024-01-17",
"type": "comment",
"previous_status": "submitted",
"approval_status": "approved"
}
],
"custom_fields": [
{
"customfield_id": "16367000000277001",
"label": "Department Code",
"value": "FIN-001"
}
]
}
}
Delete an advance payment
AI Tools
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Open in ChatGPT
Open in ChatGPT to ask questions about this page
Open in Claude
Open in Claude to ask questions about this page
Copy as Markdown
Copy this page as markdown to use with AI assistants
View as Markdown
Open this page as markdown in a new tab
Delete an existing advance payment.
OAuth Scope : ZohoExpense.advance.DELETE
Path Parameters
Headers
headers_data = Map();
headers_data.put("X-com-zoho-expense-organizationid", "10234695");
headers_data.put("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f");
response = invokeUrl
[
url: "https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203"
type: DELETE
headers: headers_data
connection: <connection_name>
];
info response;
OkHttpClient client = new OkHttpClient();
Request request = new Request.Builder()
.url("https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203")
.delete(null)
.addHeader("X-com-zoho-expense-organizationid", "10234695")
.addHeader("Authorization", "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f")
.build();
Response response = client.newCall(request).execute();
const options = {
method: 'DELETE',
headers: {
'X-com-zoho-expense-organizationid': '10234695',
Authorization: 'Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f'
}
};
fetch('https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203', options)
.then(response => response.json())
.then(response => console.log(response))
.catch(err => console.error(err));
import http.client
conn = http.client.HTTPSConnection("www.zohoapis.com")
headers = {
'X-com-zoho-expense-organizationid': "10234695",
'Authorization': "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f"
}
conn.request("DELETE", "/expense/v1/advancepayments/16367000000243203", headers=headers)
res = conn.getresponse()
data = res.read()
print(data.decode("utf-8"))
const http = require("https");
const options = {
"method": "DELETE",
"hostname": "www.zohoapis.com",
"port": null,
"path": "/expense/v1/advancepayments/16367000000243203",
"headers": {
"X-com-zoho-expense-organizationid": "10234695",
"Authorization": "Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f"
}
};
const req = http.request(options, function (res) {
const chunks = [];
res.on("data", function (chunk) {
chunks.push(chunk);
});
res.on("end", function () {
const body = Buffer.concat(chunks);
console.log(body.toString());
});
});
req.end();
curl --request DELETE \
--url https://www.zohoapis.com/expense/v1/advancepayments/16367000000243203 \
--header 'Authorization: Zoho-oauthtoken 1000.41d9xxxxxxxxxxxxxxxxxxxxxxxxc2d1.8fccxxxxxxxxxxxxxxxxxxxxxxxx125f' \
--header 'X-com-zoho-expense-organizationid: 10234695'
{
"code": 0,
"message": "Employee advance has been deleted successfully."
}