FlowmageDocs

Find deals

BetaReads dataVersion 2

Finds ActiveCampaign deals by stage, pipeline, owner, tag, value or free text.

Settings

SettingWhat it is
ConnectionRequiredThe ActiveCampaign connection the step signs in with.
Free textMatches the deal and the contact it belongs to.
Search only inOne field name, as ActiveCampaign spells it. Empty searches every field.
Title containstext
In stagetext
In pipelineActiveCampaign calls a pipeline a deal group.
StatusActiveCampaign's own status number: 0 open, 1 won, 2 lost. Empty is any.
Owner idtext
With tag idtext
Value from, in centstext
totext
Created aftertext
Created beforetext
Updated aftertext
Updated beforetext
Order by"none" or "title" or "value" or "created" or "contactName" or "contactOrganisation"
Direction"asc" or "desc"
Deals per call1 to 100. ActiveCampaign's own default is 20.
Start atZero-based. Ignored while every page is fetched.
Fetch every pageWalks the whole result, and refuses past 5,000 deals rather than answering a short list. The account shares five requests a second.
CursorPaste a previous run's Next cursor to read the page after it.
Technical details
KeyValue
connectiontexta connection id from `requires.connections` (provider `activecampaign`)
searchtext
searchFieldtextused when `search` is not ""
titletext
stageIdtext
pipelineIdtexta value from the vendor's own list
statustext
ownerIdtext
tagIdtext
minimumValuetext
maximumValuetext
createdAftertext
createdBeforetext
updatedAftertext
updatedBeforetext
sortBy"none" or "title" or "value" or "created" or "contactName" or "contactOrganisation", by default "none"
sortDirection"asc" or "desc", by default "asc"
limitnumber, by default 100
offsetnumber, by default 0
returnAlltrue/false, by default false
cursortext

Output

FieldType
dealsarray
dealCountDeals in this answernumber
totalDeals the search matchesnumber
hasMoreMore deals are waitingboolean
nextOffsetOffset for the next pagenumber
relatedSide-loaded relationsobject
nextCursorCursor for the next pagestring
Sample output, and the expression for each field
  • dealCount0
  • deals[]
  • hasMorefalse
  • nextOffset0
  • related{}
  • total0

Errors

When a step of this node stops a run, the run page shows a code. Look it up:

Example step

The step as a flow file holds it. Replace each value in <…>.

{
  "config": {
    "connection": "<connection id>",
    "createdAfter": "",
    "createdBefore": "",
    "cursor": "",
    "limit": 100,
    "maximumValue": "",
    "minimumValue": "",
    "offset": 0,
    "ownerId": "",
    "pipelineId": "",
    "returnAll": false,
    "search": "",
    "searchField": "",
    "sortBy": "none",
    "sortDirection": "asc",
    "stageId": "",
    "status": "",
    "tagId": "",
    "title": "",
    "updatedAfter": "",
    "updatedBefore": ""
  },
  "label": "Find deals",
  "type": "activecampaign.listDeals",
  "version": 2
}

Older versions

A flow that already has this version keeps running it. A new step always gets the newest.

Version 1
SettingWhat it is
ConnectionRequiredThe ActiveCampaign connection the step signs in with.
Free textMatches the deal and the contact it belongs to.
Search only inOne field name, as ActiveCampaign spells it. Empty searches every field.
Title containstext
In stagetext
In pipelineActiveCampaign calls a pipeline a deal group.
StatusActiveCampaign's own status number: 0 open, 1 won, 2 lost. Empty is any.
Owner idtext
With tag idtext
Value from, in centstext
totext
Created aftertext
Created beforetext
Updated aftertext
Updated beforetext
Order by"none" or "title" or "value" or "created" or "contactName" or "contactOrganisation"
Direction"asc" or "desc"
Deals per call1 to 100. ActiveCampaign's own default is 20.
Start atZero-based. Ignored while every page is fetched.
Fetch every pageWalks the whole result, and refuses past 5,000 deals rather than answering a short list. The account shares five requests a second.
Technical details
KeyValue
connectiontexta connection id from `requires.connections` (provider `activecampaign`)
searchtext
searchFieldtextused when `search` is not ""
titletext
stageIdtext
pipelineIdtexta value from the vendor's own list
statustext
ownerIdtext
tagIdtext
minimumValuetext
maximumValuetext
createdAftertext
createdBeforetext
updatedAftertext
updatedBeforetext
sortBy"none" or "title" or "value" or "created" or "contactName" or "contactOrganisation", by default "none"
sortDirection"asc" or "desc", by default "asc"
limitnumber, by default 100
offsetnumber, by default 0
returnAlltrue/false, by default false