Query Gifts with Full Details

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

Returns the full gift info along with the query. This can cause performance issues. We recommend using the Gift Query endpoint for quicker results. You can sort by Id, Amount, GiftDate, ReceiptDate and Batch.

Request Params

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

RESPONSES

status: OK

{"list":[{"id":"\u003cinteger\u003e","transactionSource":"\u003cstring\u003e","transactionId":"\u003cstring\u003e","contactId":"\u003cinteger\u003e","contactName":"\u003cstring\u003e","contactUrl":"\u003cstring\u003e","giftType":"\u003cstring\u003e","giftTypeFormatted":"\u003cstring\u003e","giftDate":"\u003cdateTime\u003e","giftDateFormatted":"\u003cstring\u003e","amount":"\u003cdouble\u003e","amountFormatted":"\u003cstring\u003e","currencyCode":"\u003cstring\u003e","exchangeRate":"\u003cdecimal\u003e","baseCurrencyCode":"\u003cstring\u003e","batch":"\u003cstring\u003e","createDateTimeUtc":"\u003cdateTime\u003e","createdByUser":"\u003cstring\u003e","modifiedDateTimeUtc":"\u003cdateTime\u003e","modifiedByUser":"\u003cstring\u003e","segmentId":"\u003cinteger\u003e","segment":"\u003cstring\u003e","segmentCode":"\u003cstring\u003e","segmentUrl":"\u003cstring\u003e","mediaOutletId":"\u003cinteger\u003e","mediaOutlet":"\u003cstring\u003e","grantId":"\u003cinteger\u003e","grant":"\u003cstring\u003e","grantUrl":"\u003cstring\u003e","notes":"\u003cstring\u003e","tribute":"\u003cstring\u003e","tributeId":"\u003cinteger\u003e","tributeType":"\u003cstring\u003e","acknowledgeeIndividualId":"\u003cinteger\u003e","receiptDate":"\u003cdateTime\u003e","receiptDateFormatted":"\u003cstring\u003e","contactPassthroughId":"\u003cinteger\u003e","contactPassthroughUrl":"\u003cstring\u003e","contactIndividualId":"\u003cinteger\u003e","cashAccountingCode":"\u003cstring\u003e","giftAskId":"\u003cinteger\u003e","contactMembershipId":"\u003cinteger\u003e","giftDesignations":[{"id":"\u003cinteger\u003e","projectId":"\u003cinteger\u003e","project":"\u003cstring\u003e","projectCode":"\u003cstring\u003e","externalAccountingCode":"\u003cstring\u003e","projectType":"\u003cstring\u003e","projectLocation":"\u003cstring\u003e","projectUrl":"\u003cstring\u003e","amountDesignated":"\u003cdouble\u003e","display":"\u003cstring\u003e"},{"id":"\u003cinteger\u003e","projectId":"\u003cinteger\u003e","project":"\u003cstring\u003e","projectCode":"\u003cstring\u003e","externalAccountingCode":"\u003cstring\u003e","projectType":"\u003cstring\u003e","projectLocation":"\u003cstring\u003e","projectUrl":"\u003cstring\u003e","amountDesignated":"\u003cdouble\u003e","display":"\u003cstring\u003e"}],"giftPremiums":[{"id":"\u003cinteger\u003e","premiumId":"\u003cinteger\u003e","premium":"\u003cstring\u003e","premiumUrl":"\u003cstring\u003e","quantity":"\u003cinteger\u003e","display":"\u003cstring\u003e"},{"id":"\u003cinteger\u003e","premiumId":"\u003cinteger\u003e","premium":"\u003cstring\u003e","premiumUrl":"\u003cstring\u003e","quantity":"\u003cinteger\u003e","display":"\u003cstring\u003e"}],"pledgePayments":[{"id":"\u003cinteger\u003e","expectedPaymentDate":"\u003cdateTime\u003e","expectedAmount":"\u003cdouble\u003e","giftId":"\u003cinteger\u003e","actualAmount":"\u003cdouble\u003e"},{"id":"\u003cinteger\u003e","expectedPaymentDate":"\u003cdateTime\u003e","expectedAmount":"\u003cdouble\u003e","giftId":"\u003cinteger\u003e","actualAmount":"\u003cdouble\u003e"}],"recurringGiftPayments":[{"id":"\u003cinteger\u003e","gift":{"id":"\u003cinteger\u003e","contactId":"\u003cinteger\u003e","giftDate":"\u003cdateTime\u003e","amount":"\u003cdouble\u003e"},"expectedAmount":"\u003cdouble\u003e","expectedPaymentDate":"\u003cdateTime\u003e","dismissPaymentDate":"\u003cdateTime\u003e","fulfillPaymentDate":"\u003cdateTime\u003e"},{"id":"\u003cinteger\u003e","gift":{"id":"\u003cinteger\u003e","contactId":"\u003cinteger\u003e","giftDate":"\u003cdateTime\u003e","amount":"\u003cdouble\u003e"},"expectedAmount":"\u003cdouble\u003e","expectedPaymentDate":"\u003cdateTime\u003e","dismissPaymentDate":"\u003cdateTime\u003e","fulfillPaymentDate":"\u003cdateTime\u003e"}],"giftUrl":"\u003cstring\u003e","isPrivate":"\u003cboolean\u003e","isTaxDeductible":"\u003cboolean\u003e","customFields":[{"name":"\u003cstring\u003e","value":"\u003cstring\u003e","displayName":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","value":"\u003cstring\u003e","displayName":"\u003cstring\u003e"}]},{"id":"\u003cinteger\u003e","transactionSource":"\u003cstring\u003e","transactionId":"\u003cstring\u003e","contactId":"\u003cinteger\u003e","contactName":"\u003cstring\u003e","contactUrl":"\u003cstring\u003e","giftType":"\u003cstring\u003e","giftTypeFormatted":"\u003cstring\u003e","giftDate":"\u003cdateTime\u003e","giftDateFormatted":"\u003cstring\u003e","amount":"\u003cdouble\u003e","amountFormatted":"\u003cstring\u003e","currencyCode":"\u003cstring\u003e","exchangeRate":"\u003cdecimal\u003e","baseCurrencyCode":"\u003cstring\u003e","batch":"\u003cstring\u003e","createDateTimeUtc":"\u003cdateTime\u003e","createdByUser":"\u003cstring\u003e","modifiedDateTimeUtc":"\u003cdateTime\u003e","modifiedByUser":"\u003cstring\u003e","segmentId":"\u003cinteger\u003e","segment":"\u003cstring\u003e","segmentCode":"\u003cstring\u003e","segmentUrl":"\u003cstring\u003e","mediaOutletId":"\u003cinteger\u003e","mediaOutlet":"\u003cstring\u003e","grantId":"\u003cinteger\u003e","grant":"\u003cstring\u003e","grantUrl":"\u003cstring\u003e","notes":"\u003cstring\u003e","tribute":"\u003cstring\u003e","tributeId":"\u003cinteger\u003e","tributeType":"\u003cstring\u003e","acknowledgeeIndividualId":"\u003cinteger\u003e","receiptDate":"\u003cdateTime\u003e","receiptDateFormatted":"\u003cstring\u003e","contactPassthroughId":"\u003cinteger\u003e","contactPassthroughUrl":"\u003cstring\u003e","contactIndividualId":"\u003cinteger\u003e","cashAccountingCode":"\u003cstring\u003e","giftAskId":"\u003cinteger\u003e","contactMembershipId":"\u003cinteger\u003e","giftDesignations":[{"id":"\u003cinteger\u003e","projectId":"\u003cinteger\u003e","project":"\u003cstring\u003e","projectCode":"\u003cstring\u003e","externalAccountingCode":"\u003cstring\u003e","projectType":"\u003cstring\u003e","projectLocation":"\u003cstring\u003e","projectUrl":"\u003cstring\u003e","amountDesignated":"\u003cdouble\u003e","display":"\u003cstring\u003e"},{"id":"\u003cinteger\u003e","projectId":"\u003cinteger\u003e","project":"\u003cstring\u003e","projectCode":"\u003cstring\u003e","externalAccountingCode":"\u003cstring\u003e","projectType":"\u003cstring\u003e","projectLocation":"\u003cstring\u003e","projectUrl":"\u003cstring\u003e","amountDesignated":"\u003cdouble\u003e","display":"\u003cstring\u003e"}],"giftPremiums":[{"id":"\u003cinteger\u003e","premiumId":"\u003cinteger\u003e","premium":"\u003cstring\u003e","premiumUrl":"\u003cstring\u003e","quantity":"\u003cinteger\u003e","display":"\u003cstring\u003e"},{"id":"\u003cinteger\u003e","premiumId":"\u003cinteger\u003e","premium":"\u003cstring\u003e","premiumUrl":"\u003cstring\u003e","quantity":"\u003cinteger\u003e","display":"\u003cstring\u003e"}],"pledgePayments":[{"id":"\u003cinteger\u003e","expectedPaymentDate":"\u003cdateTime\u003e","expectedAmount":"\u003cdouble\u003e","giftId":"\u003cinteger\u003e","actualAmount":"\u003cdouble\u003e"},{"id":"\u003cinteger\u003e","expectedPaymentDate":"\u003cdateTime\u003e","expectedAmount":"\u003cdouble\u003e","giftId":"\u003cinteger\u003e","actualAmount":"\u003cdouble\u003e"}],"recurringGiftPayments":[{"id":"\u003cinteger\u003e","gift":{"id":"\u003cinteger\u003e","contactId":"\u003cinteger\u003e","giftDate":"\u003cdateTime\u003e","amount":"\u003cdouble\u003e"},"expectedAmount":"\u003cdouble\u003e","expectedPaymentDate":"\u003cdateTime\u003e","dismissPaymentDate":"\u003cdateTime\u003e","fulfillPaymentDate":"\u003cdateTime\u003e"},{"id":"\u003cinteger\u003e","gift":{"id":"\u003cinteger\u003e","contactId":"\u003cinteger\u003e","giftDate":"\u003cdateTime\u003e","amount":"\u003cdouble\u003e"},"expectedAmount":"\u003cdouble\u003e","expectedPaymentDate":"\u003cdateTime\u003e","dismissPaymentDate":"\u003cdateTime\u003e","fulfillPaymentDate":"\u003cdateTime\u003e"}],"giftUrl":"\u003cstring\u003e","isPrivate":"\u003cboolean\u003e","isTaxDeductible":"\u003cboolean\u003e","customFields":[{"name":"\u003cstring\u003e","value":"\u003cstring\u003e","displayName":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","value":"\u003cstring\u003e","displayName":"\u003cstring\u003e"}]}],"total":"\u003cinteger\u003e"}