Dataset: Credit Card Transactions

Dataset name: ds_cc_transactions

Description

Credit card transactions

Fields in this dataset

Name	Field Name	Description	Field Type	Field Example
Transactions Date	cc_transaction_date	The date of the transaction	date	29222
Transactions Transaction Type	cc_transaction_type	The type of transaction	text
Transactions Description	cc_transaction_description	The transaction description	text	Cash
Transactions Value	cc_transaction_value	The value of the transaction	currency	111.11
Currency Code	cc_transaction_value_currency_code	Currency code for the transaction	text	GBP
Credit Card Transactions ID	id	The primary identifier for this record.	number	5
Credit Card Transactions Instance	instance	The instance this transaction relates to.	number	8
Credit Card Transactions Source	source	The source of the data - user or connection.	text

---

Making an API request for this Dataset

Example Request to the Sandbox Server

http://sbx-api.mydex.org/api/pds/transaction/UID.json
  ?key=KEY
  &api_key=API_KEY
  &con_id=CON_ID
  &source_type=connection
  &dataset=ds_cc_transactions
  &instance=N

Replace the following with your own details: UID KEY, API_KEY, CON_ID and instance N.

Replace sbx-api with api when making a connection to a real member on the production server (must be authenticated).

To return the data in XML, change UID.json to UID.xml.

Example Response

A response to this API request will be structured as follows.

{
  "5": {
    "id": "5",
    "ds_id": "5",
    "cc_transaction_date": "29222",
    "cc_transaction_type": null,
    "cc_transaction_description": "Cash",
    "cc_transaction_value": "111.11",
    "cc_transaction_value_currency_code": "GBP"
  }
}