Then pass the token along with the code or email to your micro-site as follows:
https://{your_micro_site}.loyal2.com/?&sso=member_code OR member_email&token= your_token

Note: tokens have a 2 hour life-span and so they need to be generated uniquely each time they are required.

Basic SQL Integration: If you only require basic SQL database integration be sure to look at our SQL Server Integration Tool - which is a simplified and automated way to read SQL data into this program.

global[member_search] - optional, use to do a text/wildcard search of first_name, last_name, company_name, email, telephone, cell and street_zipcode

API Call : get_transaction/s

Search filter fields:

member

total_value

transaction_date

transaction_ref

code

sku_code

notes

qty

ex_tax_amount

tax_amount

tax_type

grand_total

unit_price

branch

from_date

to_date

API Call : get_sku_code/s

Search filter fields:

name

code

barcode

options

notes

category

sales_price

purchase_price

archived

from_date

to_date

API Call : get_sku_category/ies

Search filter fields:

name

code

refers_to

from_date

to_date

API Call : get_points

Search filter fields:

member

points

code

transaction_date

internal_notes

branch

from_date

to_date

API Call : get_voucher/s

Search filter fields:

name

points_required

code

trigger_on_total_points_earned

points_earned_in_months

voucher_details

email_instructions

available_for_self_selection

auto_allocate_on_event

limited_to_per_member

optional_email_template

expires_after_days

can_be_redeemed_for_points

value

value_type

min_value

sku_code

date_from

date_to

group

branch

from_date

to_date

API Call : get_vouchers_issued

Search filter fields:

voucher

qty

member

transaction_date

code

points_used

branch

from_date

to_date

voucher_code - use to retrieve data for a specific voucher_code, else all associated voucher_codes will be returned

API Call : get_vouchers_precode/s

Search filter fields:

code

voucher

from_date

to_date

API Call : get_user/s

Search filter fields:

name

email

code

branch

from_date

to_date

API Call : get_branch/es

Search filter fields:

name

code

from_date

to_date

API Call : get_promotion/s

Search filter fields:

name

percent_of_spend

fixed_points_value

group

date_from

date_to

sku_code

category

code

branch

from_date

to_date

API Call : get_transactional_promotion/s

Search filter fields:

name

percent_of_spend

fixed_points_value

group

date_from

date_to

sku_code

category

code

branch

from_date

to_date

API Call : get_non_transactional_promotion/s

Search filter fields:

name

points_to_award

code

group

date_from

date_to

auto_allocate_on_event

quickscan_function

branch

from_date

to_date

API Call : add_member

Data fields:

first_name - required

last_name - required

company_name

email

cell

telephone

date_of_birth

street_address

street_address2

street_suburb

street_city

street_zipcode

street_state

optout_email

optout_text

optout_post

code

secondary_code

group

subscription_date_from

subscription_date_to

branch

suspended

_metadata01

_metadata02

_metadata03

_metadata04

_metadata05

_metadata06

_metadata07

_metadata08

_metadata09

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

global[code_editable] - optional, set flag to allow member-code to be edited.

API Call : add_transaction

Data fields:

member - required

total_value - required

transaction_date

transaction_ref

code

sku_code

notes

qty

ex_tax_amount

tax_amount

tax_type

grand_total

unit_price

branch

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_sku_code

Data fields:

name - required

code - required

barcode

options

notes

category

sales_price

purchase_price

archived

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_sku_category

Data fields:

name - required

code

refers_to

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_points

Data fields:

member - required

points - required

code

transaction_date

internal_notes

branch

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_voucher

Data fields:

name - required

points_required

code

trigger_on_total_points_earned

points_earned_in_months

voucher_details

email_instructions

available_for_self_selection

auto_allocate_on_event

limited_to_per_member

optional_email_template

expires_after_days

can_be_redeemed_for_points

value

value_type

min_value

sku_code

date_from

date_to

group

branch

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_voucher_issued

Data fields:

voucher - required

qty - required

member

transaction_date

code

points_used

branch

force_value - use to override the value of the voucher being issued/updated

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_voucher_precode

Data fields:

code - required

voucher - required

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_user

Data fields:

name - required

email - required

code

branch

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_branch

Data fields:

name

code

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_promotion

Data fields:

name

percent_of_spend - required

fixed_points_value

group

date_from

date_to

sku_code

category

code

branch

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_transactional_promotion

Data fields:

name

percent_of_spend - required

fixed_points_value

group

date_from

date_to

sku_code

category

code

branch

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : add_non_transactional_promotion

Data fields:

name

points_to_award - required

code

group

date_from

date_to

auto_allocate_on_event

quickscan_function

branch

global[edit_duplicates] - optional, set flag to edit data if a duplicate is found. Note: use with caution - empty fields will erase existing data if this is done, so only pass through the data you want to edit.

API Call : edit_member

Data fields:

first_name

last_name

company_name

email

cell

telephone

date_of_birth

street_address

street_address2

street_suburb

street_city

street_zipcode

street_state

optout_email

optout_text

optout_post

code - required

secondary_code

group

subscription_date_from

subscription_date_to

branch

suspended

_metadata01

_metadata02

_metadata03

_metadata04

_metadata05

_metadata06

_metadata07

_metadata08

_metadata09

global[code_editable] - optional, set flag to allow member-code to be edited.

API Call : edit_transaction

Data fields:

member

total_value

transaction_date

transaction_ref

code - required

sku_code

notes

qty

ex_tax_amount

tax_amount

tax_type

grand_total

unit_price

branch

API Call : edit_sku_code

Data fields:

name

code - required

barcode

options

notes

category

sales_price

purchase_price

archived

API Call : edit_sku_category

Data fields:

name

code - required

refers_to

API Call : edit_points

Data fields:

member

points

code - required

transaction_date

internal_notes

branch

API Call : edit_voucher

Data fields:

name

points_required

code - required

trigger_on_total_points_earned

points_earned_in_months

voucher_details

email_instructions

available_for_self_selection

auto_allocate_on_event

limited_to_per_member

optional_email_template

expires_after_days

can_be_redeemed_for_points

value

value_type

min_value

sku_code

date_from

date_to

group

branch

API Call : edit_voucher_issued

Data fields:

voucher

qty

member

transaction_date

code - required

points_used

branch

force_value - use to override the value of the voucher being issued/updated

voucher_code - use to modify data for a specific voucher_code, replaces need to use 'code' (above) to locate the voucher_issued data record