Query Projects

POST {{baseUrl}}/api/Project/Query?skip=<integer>&take=<integer>

To see which options can be sent, use the {M:Virtuous.WebApi.Controllers.ProjectController.QueryOptions} endpoint. If you're going to consistently query for updated projects or new projects, don't. Use a webhook instead. If requests are timing out, you may be asking for too many items at once. The max take is 1,000.

Request Params

KeyDatatypeRequiredDescription
skipstringThe number of records to skip. Default = 0.
takestringThe number of records to take. Default = 10. Max is 1000.

Request Body

{"groups"=>[{"conditions"=>[{"parameter"=>"<string>", "operator"=>"<string>", "value"=>"<string>", "secondaryValue"=>"<string>", "values"=>["<string>", "<string>"]}, {"parameter"=>"<string>", "operator"=>"<string>", "value"=>"<string>", "secondaryValue"=>"<string>", "values"=>["<string>", "<string>"]}]}, {"conditions"=>[{"parameter"=>"<string>", "operator"=>"<string>", "value"=>"<string>", "secondaryValue"=>"<string>", "values"=>["<string>", "<string>"]}, {"parameter"=>"<string>", "operator"=>"<string>", "value"=>"<string>", "secondaryValue"=>"<string>", "values"=>["<string>", "<string>"]}]}], "sortBy"=>"<string>", "descending"=>"<boolean>"}

HEADERS

KeyDatatypeRequiredDescription
Content-Typestring

RESPONSES

status: OK

{&quot;list&quot;:[{&quot;id&quot;:&quot;\u003cinteger\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;projectCode&quot;:&quot;\u003cstring\u003e&quot;,&quot;externalAccountingCode&quot;:&quot;\u003cstring\u003e&quot;,&quot;onlineDisplayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;photoUrl&quot;:&quot;\u003cstring\u003e&quot;,&quot;parentId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;parentName&quot;:&quot;\u003cstring\u003e&quot;,&quot;isSubProject&quot;:&quot;\u003cboolean\u003e&quot;,&quot;inventoryStatus&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;location&quot;:&quot;\u003cstring\u003e&quot;,&quot;isRestrictedToGiftSpecifications&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isLimitedToFinancialNeed&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isPublic&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isActive&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isAvailableOnline&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isTaxDeductible&quot;:&quot;\u003cboolean\u003e&quot;,&quot;treatAsAccountsPayable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;beginningBalance&quot;:&quot;\u003cdouble\u003e&quot;,&quot;currentBalance&quot;:&quot;\u003cdouble\u003e&quot;,&quot;financialNeedType&quot;:&quot;\u003cstring\u003e&quot;,&quot;financialNeedFrequency&quot;:&quot;\u003cstring\u003e&quot;,&quot;financialNeedAmount&quot;:&quot;\u003cdouble\u003e&quot;,&quot;startDate&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;endDate&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;durationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifeToDateGiving&quot;:&quot;\u003cdouble\u003e&quot;,&quot;lifeToDateGiftCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;lifeToDateGiversCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;lifeToDateExpenseTotal&quot;:&quot;\u003cdouble\u003e&quot;,&quot;calendarYearToDateGiving&quot;:&quot;\u003cdouble\u003e&quot;,&quot;calendarYearToDateGiftCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;calendarYearToDateGiversCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;calendarYearToDateExpenseTotal&quot;:&quot;\u003cdouble\u003e&quot;,&quot;createDateTimeUtc&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;createdByUser&quot;:&quot;\u003cstring\u003e&quot;,&quot;modifiedDateTimeUtc&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;modifiedByUser&quot;:&quot;\u003cstring\u003e&quot;,&quot;giftSpecifications&quot;:[{&quot;amount&quot;:&quot;\u003cdouble\u003e&quot;,&quot;frequency&quot;:&quot;\u003cstring\u003e&quot;},{&quot;amount&quot;:&quot;\u003cdouble\u003e&quot;,&quot;frequency&quot;:&quot;\u003cstring\u003e&quot;}],&quot;customFields&quot;:&quot;\u003cobject\u003e&quot;},{&quot;id&quot;:&quot;\u003cinteger\u003e&quot;,&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;projectCode&quot;:&quot;\u003cstring\u003e&quot;,&quot;externalAccountingCode&quot;:&quot;\u003cstring\u003e&quot;,&quot;onlineDisplayName&quot;:&quot;\u003cstring\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;photoUrl&quot;:&quot;\u003cstring\u003e&quot;,&quot;parentId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;parentName&quot;:&quot;\u003cstring\u003e&quot;,&quot;isSubProject&quot;:&quot;\u003cboolean\u003e&quot;,&quot;inventoryStatus&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;\u003cstring\u003e&quot;,&quot;location&quot;:&quot;\u003cstring\u003e&quot;,&quot;isRestrictedToGiftSpecifications&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isLimitedToFinancialNeed&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isPublic&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isActive&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isAvailableOnline&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isTaxDeductible&quot;:&quot;\u003cboolean\u003e&quot;,&quot;treatAsAccountsPayable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;beginningBalance&quot;:&quot;\u003cdouble\u003e&quot;,&quot;currentBalance&quot;:&quot;\u003cdouble\u003e&quot;,&quot;financialNeedType&quot;:&quot;\u003cstring\u003e&quot;,&quot;financialNeedFrequency&quot;:&quot;\u003cstring\u003e&quot;,&quot;financialNeedAmount&quot;:&quot;\u003cdouble\u003e&quot;,&quot;startDate&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;endDate&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;durationType&quot;:&quot;\u003cstring\u003e&quot;,&quot;lifeToDateGiving&quot;:&quot;\u003cdouble\u003e&quot;,&quot;lifeToDateGiftCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;lifeToDateGiversCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;lifeToDateExpenseTotal&quot;:&quot;\u003cdouble\u003e&quot;,&quot;calendarYearToDateGiving&quot;:&quot;\u003cdouble\u003e&quot;,&quot;calendarYearToDateGiftCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;calendarYearToDateGiversCount&quot;:&quot;\u003cinteger\u003e&quot;,&quot;calendarYearToDateExpenseTotal&quot;:&quot;\u003cdouble\u003e&quot;,&quot;createDateTimeUtc&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;createdByUser&quot;:&quot;\u003cstring\u003e&quot;,&quot;modifiedDateTimeUtc&quot;:&quot;\u003cdateTime\u003e&quot;,&quot;modifiedByUser&quot;:&quot;\u003cstring\u003e&quot;,&quot;giftSpecifications&quot;:[{&quot;amount&quot;:&quot;\u003cdouble\u003e&quot;,&quot;frequency&quot;:&quot;\u003cstring\u003e&quot;},{&quot;amount&quot;:&quot;\u003cdouble\u003e&quot;,&quot;frequency&quot;:&quot;\u003cstring\u003e&quot;}],&quot;customFields&quot;:&quot;\u003cobject\u003e&quot;}],&quot;total&quot;:&quot;\u003cinteger\u003e&quot;}