API Transaction - Revision history

Admin: /* Optional Parameters */

2018-06-06T05:13:28Z

Optional Parameters

Admin: /* Optional Parameters */

2018-06-06T05:13:05Z

Optional Parameters

Admin: /* Optional Parameters */

2018-06-06T05:12:39Z

Optional Parameters

Admin: /* Transaction Properties */

2018-06-06T05:12:00Z

Transaction Properties

Admin at 23:48, 1 November 2016

2016-11-01T23:48:11Z

Admin: /* Transaction Properties */

2016-10-27T02:37:15Z

Transaction Properties

Admin at 00:28, 13 October 2016

2016-10-13T00:28:37Z

Admin at 23:06, 12 October 2016

2016-10-12T23:06:44Z

Admin at 23:05, 12 October 2016

2016-10-12T23:05:39Z

Admin: Created page with "The Spiffy Stores API Transaction object represents a transaction that has been applied to an order. There are five types of transactions that can be applied to an order. * ..."

2016-10-12T23:04:09Z

Created page with "The Spiffy Stores API Transaction object represents a transaction that has been applied to an order. There are five types of transactions that can be applied to an order. * ..."

New page

The Spiffy Stores API Transaction object represents a transaction that has been applied to an order.

There are five types of transactions that can be applied to an order.

* '''Sale''': The amount of money transferred from the cardholder's account to pay the outstanding order.
* '''Authorization''': This represents the amount which has been reserved against the cardholder's account. No money changes hands until an authorization is captured.
* '''Capture''': This occurs only after an authorization has been approved, and records the actual transfer of funds from the cardholder's account.
* '''Void''': This represents the cancellation of a pending authorization or capture.
* '''Refund''': A full or partial return of captured funds to the cardholder can occur. A refund can only happen after a capture or sale is processed.

== Transaction Properties ==

<html>
<style type="text/css">
table.wikitable td { padding: 10px 20px !important; text-align: left; vertical-align: middle; }
</style>
</html>
{| class="wikitable" style="width: 100%"
|style="width: 30%"|id
|<code>{ "id" : 123456789 }</code> 
A unique numeric identifier for the transaction. This ID is only used with the API interface.
|-
|order_id
|<code>{ "order_id" : 452983 }</code> 
The internal ID of the associated order.
|-
|sequence
|<code>{ "sequence" : 1 }</code> 
The sequence number of the transaction.
|-
|amount
|<code>{ "amount" : 54.53 }</code> 
The value of the transaction.
|-
|authorization
|<code>{ "authorization" : "A235467-239934" }</code> 
The authorization code associated with the transaction.
|-
|transaction_id
|<code>{ "transaction_id" : "823048203" }</code> 
The transaction id that has been returned by the payment gateway.
|-
|created_at
|<code>{ "created_at" : "2015-10-24T18:26:31Z" }</code> 
The date and time when the transaction was created. The timestamp is in ISO 8601 format.
|-
|gateway
|<code>{ "gateway" : "Big Bank" }</code> 
The name of the payment gateway which processed the transaction.
|-
|kind
|<code>{ "kind" : "sale" }</code> 
The kind of transaction. 
The following values can be returned: '''sale''', '''authorization''', '''capture''', '''void''' and '''refund'''.
|-
|status
|<code>{ "status" : "success" }</code> 
The status of the transaction. 
The following values can be returned: '''pending''', '''failure''', '''succes''' and '''error'''.
|-
|description
|<code>{ "description" : "Additional information about the transaction" }</code> 
In some cases some additional information may be returned by the payment gateway.
|-
|source_name
|<code>{ "source_name" : "web" }</code> 
The origin of the transaction. Currently, only '''web''' is returned.
|-
|currency
|<code>{ "currency" : "AUD" }</code> 
The currency used for the transaction.
|-
|payment_details
|<code>{ "payment_details" : {   "avs_result_code" : null,
   "credit_card_bin" : "411111",
   "cvv_result_code" : null,
   "credit_card_number" : "4111 11XX XXXX 1234",
   "credit_card_company" : "Visa",
   "credit_card_issuing_bank" : "Big Bank",
   "minfraud_risk_score" : 0.15 }</code> 
Returns an object containing information about the credit card that was used for this transaction.

The following properties are supported:

* avs_result_code - The response code from the Address Verification System. This code is only available from US, Canadian and UK payment gateways.
* credit_card_number - The customer's partial credit card number.
* credit_card_bin - The issuer identification number (IIN), formerly known as bank identification number (BIN) of the customer's credit card. This is made up of the first few digits of the credit card number.
* credit_card_company - The name of the company who issued the customer's credit card.
* credit_card_issuing_bank - The name of the financial institution that issued the customer's credit card.
* cvv_result_code - The Response code from the credit card company indicating whether the customer entered the card security code correctly.
* minfraud_risk_score - The risk score for the transaction, if available.
|}

== Endpoints ==

=== <code>GET /api/orders/ORDER_ID/transactions.json</code> ===

Return a list of transacions belonging to a specific order. Use the optional parameters to return specific transactions.

=== <code>GET /api/transactions.json</code> ===

Return a list of transactions belonging to a store. Use the optional parameters to return specific transactions.

==== Optional Parameters ====

{| class="wikitable" style="width: 100%"
|style="width: 30%"|limit
|Number of results returned. The default is 30, with a maximum of 50 in a single request.
|-
|page
|The number of the page to return. The number of results per page is set by the <code>limit</code> parameter. If more results are required, then submit the request again, increasing the page number each time.
|-
|ids
|A comma-separated list of transaction ids.
|-
|since_id
|Limit the results to only include objects which have an id greater than the given value.
|-
|created_at_min
|Return only the transactions created after the given date and time. Use the format "2014-12-31 12:00".
|-
|created_at_max
|Return only the transactions created before the given date and time. Use the format "2014-12-31 12:00".
|-
|order_id
|Return all the transactions belonging to the specified order.
|-
|fields
|A comma-separated list of fields to return in the response.
|}

==== Example Request and Response ====

<pre>
GET /api/transactions.json

HTTP/1.1 200 OK

{
"transactions": [
{
"id": 34169,
"order_id": 768969,
"sequence": 1,
"amount": "123.50",
"kind": "sale",
"gateway": "bogus",
"status": "success",
"description": null,
"created_at": "2015-08-05T12:59:12-04:00",
"authorization": "123456789",
"transaction_id": "A3w47983",
"currency": "AUD",
"source_name": "web"
}, ...
]
}

Examples using filters

GET /api/orders/234234/transactions.json?limit=10

GET /api/transactions.json?order_id=2322

</pre>

=== <code>GET /api/orders/ORDER_ID/transactions/count.json</code> ===

Return a count of transactions belonging to an order.

=== <code>GET /api/transactionss/count.json</code> ===

Return a count of transactions belonging to a store.

==== Optional Parameters ====

{| class="wikitable" style="width: 100%"
|style="width: 30%"|since_id
|Limit the results to only include objects which have an id greater than the given value.
|-
|created_at_min
|Return only the transactions created after the given date and time. Use the format "2014-12-31 12:00".
|-
|created_at_max
|Return only the transactions created before the given date and time. Use the format "2014-12-31 12:00".
|-
|order_id
|Return all the transactions belonging to the specified order.
|}

==== Example Request and Response ====

<pre>
GET /api/orders/12345/transactions/count.json

HTTP/1.1 200 OK

{
"count": 3
}

Examples using filters

GET /api/transactions/count.json?order_id=2322
</pre>

=== <code>GET /api/orders/ORDER_ID/transactions/TRANSACTION_ID.json</code> ===

Return a single transaction belonging to an order.

=== <code>GET /api/transactions/TRANSACTION_ID.json</code> ===

Return a single transaction belonging to a store.

==== Optional Parameters ====

{| class="wikitable" style="width: 100%"
|style="width: 30%"|fields
|A comma-separated list of fields to return in the response.
|}

==== Example Request and Response ====

<pre>
GET /api/transactions/443169.json

HTTP/1.1 200 OK

{
"transaction":
{
"id": 34169,
"order_id": 768969,
"sequence": 1,
"amount": "123.50",
"kind": "sale",
...
}
}

</pre>

 

== Further Reference ==

* [[An Introduction to the Spiffy Stores API]]
* [[Creating Private API Keys]]
* [[Using the API]]
* [[API Reference]]

@@ Line 11: / Line 11: @@
 == Transaction Properties ==
-<html>
+{| class="reference"
-  <style type="text/css">
+!id
 |<code>{ "id" : 123456789 }</code><br/>
 A unique numeric identifier for the transaction. This ID is only used with the API interface.
 |-
-|order_id
+!order_id
 |<code>{ "order_id" : 452983 }</code><br/>
 The internal ID of the associated order.
 |-
-|order_number
+!order_number
 |<code>{ "order_number" : 1045 }</code><br/>
 A unique numeric identifier for the order that is used as a reference number for the store owner and customers. This is not the same as the internal ID of the order, which is only used to refer to orders within the API.
 |-
-|order_name
+!order_name
 |<code>{ "order_name" : "#001045" }</code><br/>
 This is the order_number, formatted according the the store preferences for order number formatting.
 |-
-|sequence
+!sequence
 |<code>{ "sequence" : 1 }</code><br/>
 The sequence number of the transaction.
 |-
-|amount
+!amount
 |<code>{ "amount" : 54.53 }</code><br/>
 The value of the transaction.
 |-
-|fee
+!fee
 |<code>{ "fee" : 0.55 }</code><br/>
 The value of the merchant fee associated with the transaction, if provided by the gateway.
 |-
-|authorization
+!authorization
 |<code>{ "authorization" : "A235467-239934" }</code><br/>
 The authorization code associated with the transaction.
 |-
-|transaction_id
+!transaction_id
 |<code>{ "transaction_id" : "823048203" }</code><br/>
 The transaction id that has been returned by the payment gateway.
 |-
-|created_at
+!created_at
 |<code>{ "created_at" : "2015-10-24T18:26:31Z" }</code><br/>
 The date and time when the transaction was created. The timestamp is in ISO 8601 format.
 |-
-|gateway
+!gateway
 |<code>{ "gateway" : "Big Bank" }</code><br/>
 The name of the payment gateway which processed the transaction.
 |-
-|kind
+!|kind
 |<code>{ "kind" : "sale" }</code><br/>
 The kind of transaction.<br/>
 The following values can be  returned: '''sale''', '''authorization''', '''capture''', '''void''' and '''refund'''.
 |-
-|status
+!status
 |<code>{ "status" : "success" }</code><br/>
 The status of the transaction.<br/>
 The following values can be  returned: '''pending''', '''failure''', '''succes''' and '''error'''.
 |-
-|description
+!description
 |<code>{ "description" : "Additional information about the transaction" }</code><br/>
 In some cases some additional information may be returned by the payment gateway.
 |-
-|source_name
+!source_name
 |<code>{ "source_name" : "web" }</code><br/>
 The origin of the transaction. Currently, only '''web''' is returned.
 |-
-|currency
+!currency
 |<code>{ "currency" : "AUD" }</code><br/>
 The currency used for the transaction.
 |-
-|payment_details
+!payment_details
 |<code>{ "payment_details" : {
 &nbsp;&nbsp;"avs_result_code" : null,

@@ Line 72: / Line 72: @@
 |-
 |payment_details
-|<code>{ "payment_details" : {<br/>&nbsp;&nbsp;"avs_result_code" : null,
+|<code>{ "payment_details" : {
-&nbsp;&nbsp;"credit_card_bin" : "411111",
+&nbsp;&nbsp;"avs_result_code" : null,
-&nbsp;&nbsp;"cvv_result_code" : null,
+<br/>&nbsp;&nbsp;"credit_card_bin" : "411111",
-&nbsp;&nbsp;"credit_card_number" : "4111 11XX XXXX 1234",
+<br/>&nbsp;&nbsp;"cvv_result_code" : null,
-&nbsp;&nbsp;"credit_card_company" : "Visa",
+<br/>&nbsp;&nbsp;"credit_card_number" : "4111 11XX XXXX 1234",
-&nbsp;&nbsp;"credit_card_issuing_bank" : "Big Bank",
+<br/>&nbsp;&nbsp;"credit_card_company" : "Visa",
-&nbsp;&nbsp;"minfraud_risk_score" : 0.15 }</code><br/>
+<br/>&nbsp;&nbsp;"credit_card_issuing_bank" : "Big Bank",
 Returns an object containing information about the credit card that was used for this transaction.

@@ Line 73: / Line 73: @@
 |payment_details
 |<code>{ "payment_details" : {<br/>&nbsp;&nbsp;"avs_result_code" : null,
-<br/>&nbsp;&nbsp;"credit_card_bin" : "411111",
+&nbsp;&nbsp;"credit_card_bin" : "411111",
-<br/>&nbsp;&nbsp;"cvv_result_code" : null,
+&nbsp;&nbsp;"cvv_result_code" : null,
-<br/>&nbsp;&nbsp;"credit_card_number" : "4111 11XX XXXX 1234",
+&nbsp;&nbsp;"credit_card_number" : "4111 11XX XXXX 1234",
-<br/>&nbsp;&nbsp;"credit_card_company" : "Visa",
+&nbsp;&nbsp;"credit_card_company" : "Visa",
-<br/>&nbsp;&nbsp;"credit_card_issuing_bank" : "Big Bank",
+&nbsp;&nbsp;"credit_card_issuing_bank" : "Big Bank",
-<br/>&nbsp;&nbsp;"minfraud_risk_score" : 0.15 }</code><br/>
+&nbsp;&nbsp;"minfraud_risk_score" : 0.15 }</code><br/>
 Returns an object containing information about the credit card that was used for this transaction.

@@ Line 223: / Line 223: @@
 ==== Optional Parameters ====
-{| class="wikitable" style="width: 100%"
+{| class="reference"
-|style="width: 30%"|fields
+!fields
 |A comma-separated list of fields to return in the response.
 |}

@@ Line 183: / Line 183: @@
 ==== Optional Parameters ====
-{| class="wikitable" style="width: 100%"
+{| class="reference"
-|style="width: 30%"|since_id
+!since_id
 |Limit the results to only include objects which have an id greater than the given value.
 |-
-|created_at_min
+!created_at_min
 |Return only the transactions created after the given date and time. Use the format "2014-12-31 12:00".
 |-
-|created_at_max
+!created_at_max
 |Return only the transactions created before the given date and time. Use the format "2014-12-31 12:00".
 |-
-|order_id
+!order_id
 |Return all the transactions belonging to the specified order.
 |}

@@ Line 97: / Line 97: @@
 === <code>GET /api/orders/ORDER_ID/transactions.json</code> ===
-Return a list of transacions belonging to a specific order. Use the optional parameters to return specific transactions.
+Return a list of transactions belonging to a specific order. Use the optional parameters to return specific transactions.
 === <code>GET /api/transactions.json</code> ===