Data Delivery Service (DDS) enables you to export your data from 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 Required string Comma separated list of fields on the object to list. Use * to return all fields.
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 Required string Comma separated list of fields on the object to get. Use * to return all fields.

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 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