Figure out best way to get Braintree audit files and then get them
Closed, ResolvedPublic
Actions

Description

Looks like we can either get it through GraphQL or through their API:

GraphQL endpoint: https://graphql.braintreepayments.com/reference/#object--transactionlevelfeereport (get report url, need verify with braintree see if we are qualify with this report type)
Graphql for Search : https://graphql.braintreepayments.com/reference/#object--search (get transactions)

API way: https://developer.paypal.com/braintree/docs/guides/reports/settlement-batch-summaries

Try and get a report from GraphQL and see if its what we need

Details

	Subject	Repo	Branch	Lines +/-
	Add report or search result for transactions	wikimedia/fundraising/SmashPig	master	+694 -12
	Add report or search result for transactions	wikimedia/fundraising/SmashPig	master	+284 -5

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Cstone	T303442 break down Download and parse Braintree audit files task
		Resolved		AnnWF	T310756 Figure out best way to get Braintree audit files and then get them

Event Timeline

Cstone created this task.Jun 15 2022, 11:11 PM

Cstone removed Cstone as the assignee of this task.Jun 15 2022, 11:20 PM

XenoRyet moved this task from Triage to Current Sprint on the Fundraising-Backlog board.Jun 21 2022, 7:48 PM

XenoRyet added a project: Fundraising Sprint Localhost Hospitality Studies.Jun 21 2022, 8:31 PM

Cstone updated the task description. (Show Details)Jun 21 2022, 10:43 PM

Cstone updated the task description. (Show Details)

Change 808008 had a related patch set uploaded (by Wfan; author: Wfan):

[wikimedia/fundraising/SmashPig@master] wip: Add report or search for transactions (report is limited to paymentLevel)

https://gerrit.wikimedia.org/r/808008

gerritbot added a project: Patch-For-Review.Jun 23 2022, 2:57 PM

AnnWF moved this task from Backlog to Doing on the Fundraising Sprint Localhost Hospitality Studies board.Jun 23 2022, 2:58 PM

@Ejegg Since we are not getting any payment level report, as we can see here also https://sandbox.braintreegateway.com/merchants/ms9fqmw9gxrm2bp3/transaction_level_fee_reports/run?utf8=%E2%9C%93&report_criteria%5Bmerchant_account_token%5D=wikimediafoundation&report_criteria%5Bstart_date%5D=06%2F01%2F2022&report_criteria%5Bend_date%5D=06%2F30%2F2022&commit=Run+Transaction-Level+Fee+Report (was called transaction level fee report)

and that make me wonder if we are not qualified with this report as https://developer.paypal.com/braintree/articles/control-panel/reporting/transaction-level-fee-report indicated if we are not using IC+ pricing models nor Flat rate and blended pricing models. can also do the testing with php PaymentProviders/Braintree/Maintenance/GetReport.php. then I find another way to get the transaction list which we can use php PaymentProviders/Braintree/Maintenance/TestSearch.php for yesterday's transactions. need some opinion if none of those is acceptable, then we can switch to the SDK approach~

AnnWF claimed this task.Jun 23 2022, 5:45 PM

AnnWF updated the task description. (Show Details)

AnnWF moved this task from Doing to Review on the Fundraising Sprint Localhost Hospitality Studies board.

AnnWF moved this task from Backlog to Review on the Fundraising Sprint Kermit hopping principle board.Jun 24 2022, 5:08 PM

jgleeson moved this task from Backlog to Doing on the FR-Braintree-Integration board.Jul 5 2022, 8:12 PM

XenoRyet added a project: Fundraising Sprint Machine Unlearning.Jul 5 2022, 8:23 PM

AnnWF moved this task from Backlog to Review on the Fundraising Sprint Machine Unlearning board.Jul 5 2022, 8:41 PM

Change 808008 abandoned by Wfan:

[wikimedia/fundraising/SmashPig@master] Add report or search result for transactions

Reason:

https://gerrit.wikimedia.org/r/808008

Maintenance_bot removed a project: Patch-For-Review.Jul 13 2022, 4:31 PM