Introduction

ADR – In the Annex Cloud ADR platform, we has a UI and API for the Tango Summary and Chart.

Below are the instructions explaining how to create and use Tango reports.

Tango Configuration

Navigation:
Login to ADR Site → Products → Pre-Build Integrations → Tango Settings

• Annex Cloud has implemented CRUD operations for the Tango configuration settings.
• The fields for the Tango configuration are:
  • Username
  • Tango Key
  • Account Name
  • Account Identifier
• Data is saved in the Annex Cloud database. The table name is master_tango_config.

API:
Annex Cloud has created the following API for CRUD operations:

• Request URL: https://apps.socialannex.com/pos/admin/v1/tango?site_id=111575520
• Method: GET, POST, UPDATE, DELETE
  

Tango Chart Report

Navigation:
Login to ADR Site → Reports → Gift Card → Tango → Tango Chart Report

• The Tango Chart Report uses a combination of AC DB queries and Tango APIs.
• The Tango Chart Report shows orders from the Juice Plus account, created on Tango Reward Genius https://sandbox-manage.rewardsgenius.com/#/groups
• Here is an illustration for the Juice Plus account on Tango Reward Genius.
• Below are the APIs used in the Tango Chart Report:

Tango API for Available Balance

• Request URL: https://integration-api.tangocard.com/raas/v2/accounts/A59309284 
• Method: GET
• Accept: application/json
• Authorization: Annex Cloud will provide authorization.

AC DB Query for Points Redemption

• We use a combination of the following tables:
  • master_tango_config
  • s15_v3_transaction
• Pass the Site ID in the WHERE clause to get the total points redemption for that Site ID.
• Pass the Action ID (107) and Site ID in the WHERE clause.
• The result is shown in the Points Redemption Chart.

AC DB Query for Amount Spent

• We use a combination of the following tables:
  • master_tango_config
  • s15_v3_transaction
• Pass the Site ID in the WHERE clause to get the total amount spent for that Site ID.
• Pass the Action ID (109) and Site ID in the WHERE clause.
• The result is shown in the Amount Spend Chart.

Column Chart for Today's Top Order

• We use a combination of the following tables:
  • master_tango_config
  • s15_v3_transaction
• Pass the Site ID and the current date in the WHERE clause to get the total orders for today.
• Use this data to generate the column chart for "Today's Top Orders."

Query for Column Chart Data

• We use a combination of the following tables:
  • master_tango_config
  • s15_v3_transaction
• User
• Pass the Site ID and User ID in the WHERE clause to get the top orders for the day, along with the member’s email address.
• The result includes: Email Address, Points Redemption, Available Points, which is used to populate the column chart.
  

Rewards Dashboard

• Click on the "Redeem" tab and scroll down to Gift Cards.
• Click on the Redeem button to redeem the reward.
  
• After clicking the Redeem button, a pop-up window will appear. Click OK to proceed.
• Scroll down the Rewards Dashboard page to see the Redeemed Rewards table.
  

API for Redeeming Gift Cards

• Request URL: https://api.socialannex.com/tango/order.php
• Method: POST
• Payload:

acTangoData={  
     "accountIdentifier": "testannexcloud",  
     "amount": amt,  
     "customerIdentifier": "testannexcloud",  
     "sendEmail": false,  
     "utid": "U579023",  
     "siteId": s15_siteId,  
     "userId": s15_Id,  
     "rewardId":rId  
   }