Skip to content

Fetch Schedule's Accounts

Merciglobal Cloud ERP: API for Accounts by Schedule Name

Merciglobal Cloud ERP provides a reliable API to fetch all account details linked to a specific Schedule Name, along with data filtered by a date range. This guide is intended for internal developers, the sales team, and customers to seamlessly integrate schedule-based account lookups into their applications.

API Endpoint

GET https://devx.merciglobal.com/apis/ajax.php?sys_projectfolder=PROJECT_NAME&func=scheduleDet&schedule=SCHEDULE_NAME&sdate=START_DATE&edate=END_DATE

Parameters

Parameter Description
sys_projectfolder (String) Name of your project folder in the Merciglobal Cloud ERP system
func (String) Must be set to scheduleDet
schedule (String) The schedule name for which all related accounts need to be fetched
sdate (String) Start date in YYYY-MM-DD format to filter account data
edate (String) End date in YYYY-MM-DD format to filter account data

Use Cases

  • Finance Teams: Retrieve all accounts grouped under a specific financial schedule during a specified period
  • Sales Teams: Identify client categories and manage offerings accordingly over time
  • Customers: Automate classification and analysis of account types based on schedules with date-based filters

Integration Tips

  • Ensure the schedule parameter matches the naming convention used in your ERP instance
  • Dates must be in YYYY-MM-DD format and logically consistent
  • Encode special characters in the URL (e.g., spaces as %20)
  • Use this endpoint server-side to keep schedule names and date queries secure

Sample Request

curl "https://devx.merciglobal.com/apis/ajax.php?sys_projectfolder=erp2025&func=scheduleDet&schedule=Assets&sdate=2025-01-01&edate=2025-06-30"

Notes

  • Validate that your project has access rights to schedule-based APIs
  • This API enhances visibility into financial classifications within your Merciglobal ERP, especially across custom timeframes

For any help, please reach out to your Merciglobal account manager or the ERP API support team.

Stay informed—Subscribe to the Merciglobal Developer Digest for updates and insights.