RESTful API enhancements

  • Order returned records. The GET operations that retrieve all entity records have been updated to provide an orderBy system query option. You can use orderBy to order the returned records by the value of a specified field in the ascending (asc) or descending (desc) order.

    For more information about the operations that support orderBy, see Sage CRM 2024 R2 RESTful API reference.

    Example

    Copy 
    curl --location 'http://mycrmserver/sdata/CRMj/sagecrm2/-/Address?orderBy=addr_address2%20desc' --header 'Authorization: Basic QWRtaW46'

    Retrieves all Address records and orders them by the value of the addr_address2 field in the descending order.

See also What's new in the RESTful API documentation.