RE NXT Gift List Endpoint - Recurring Gifts

Matt Thacker

I'm using the Gift List endpoint and on the schema it has return values for all of the information associated with recurring gifts (frequency, start date, next transaction date, etc.). However, the object that's returned does not include information (I've attached a pdf with a screenshot of the side by side of JSON returned for a recurring gift and the schema according to the endpoint documentation.

],

RecurringGiftDoc.pdf

Alex Wong

@Matt Thacker
This may be the reason:

Is your Recurring Gift those that is created in the webview and/or using RE NXT Donation form? or are they old Recurring Gift from database view that came in from Online Express or NetCommunity (or manually).

Ecleva Tech

@Alex Wong
Is there a way we can get other recurring gift which are not automate and coming from database view?
If that is not supported through API then another way which help me to retrieve data from Database view?

Thanks in advance!
Jaymin

Alex Wong

@Ecleva Tech
When SKY API doesn't provide the info, you will have to resort to database view query/export. RE:Queue can help automate the processs of exporting

Ecleva Tech

@Alex Wong thanks for prompt response!
Could you please provide me a bit more details if you can to access data through query without export and I would like to automate this details.
Thanks again!
Jaymin

Alex Wong

@Ecleva Tech
Basically for information that isn't available or perhaps too difficult to get on SKY API, you can use the database view to run the data.

Not sure if you are familiar with database view or not. It is basically an application of RE before RE NXT webview comes to live. It has querying capability on most (99%) of data available on RE. Query, Export, or Import>Export provide various means to get data in CSV format. Depending on your data need, you will choose between one of those 3 options. Once the data is in CSV format, you will be able to retrieve the information programmatically (Power Automat flow, or other programming). The exporting of data is manually done, however.

RE:Queue is simply a “scheduler". Meaning, you can use it to schedule export of pre-saved query/export/import>export. This can be daily/nightly/every few hours. With this, you can make the automation tool you use to automatically get the CSV for processing in the same scheduled interval. Here's a post I wrote about getting CSV into excel in SharePoint.

As for potentially the data you seek, you can find it in a gift query under “installment section”