Data Delivery Service (DDS) enables you to export your data from Sage Intacct to a cloud destination.


List DDS Jobs

readByQuery

<readByQuery>
    <object>DDSJOB</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameter

Name Required Type Description
object Required string Use DDSJOB
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

Get DDS Job

read

<read>
    <object>DDSJOB</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use DDSJOB
keys Required string The job RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create DDS Job

runDdsJob

Create job to get all vendors.

<runDdsJob>
    <object>VENDOR</object>
    <cloudDelivery>AWS-S3-DDS</cloudDelivery>
    <jobType>all</jobType>
</runDdsJob>

Create job to get changed customers

<runDdsJob>
    <object>CUSTOMER</object>
    <cloudDelivery>AWS-S3-DDS</cloudDelivery>
    <jobType>change</jobType>
</runDdsJob>

Parameters

Name Required Type Description
object Required string Object integration name
cloudDelivery Required string Cloud storage destination name as defined in the Sage Intacct system (under Company > Setup > Cloud Storage).
jobType Optional string Job type. Use change for all changes since the last delivery, otherwise use all for all data.
timeStamp Optional string Timestamp to get data from if jobType is change. Format YYYY-MM-DDThh:mm:ss
fileConfiguration Optional object File attributes

fileConfiguration

Name Required Type Description
delimiter Optional string Value delimiter. Use . for Period, ; for Semicolon, or , for Comma (Default: , Comma)
enclosure Optional string Text qualifier. Use " for Double quote, ' for Single quote, [ for Left bracket, or / for Forward Slash (Default: " Double quote)
includeHeaders Optional boolean Include column headers. Use true for Yes otherwise false for No (Default: false)
fileFormat Optional string File format. Use windows, mac, or unix (Default: unix)
splitSize Optional integer Split files after this many records. Minimum is 10000 and maximum is 100000.
compress Optional boolean Compress file. Use true for Yes otherwise false for No (Default: false)

Provide feedback