API to change rows status


I have been provided with an API system from [url removed, login to view] and a document on how to use their API (file attached) and I want it to look up in my account all Transactions which have the status set to confirmed in the past 2 months every time its ran maybe.

When it gets this list it wants to look whats in the click_ref column and then with this number connect to the websites database look in table 'accounts' for the row with this ID number and then set the status to confirmed it then all wants to get the commission column from the API system and in the amount column on the database it wants to put this amount in there but before it does divide it by 2 and then put the amount in this field.

Thanks a lot.

Kind Regards,

Matt Lovett

Færdigheder: Perl, PHP, Windows Skrivebord

Se mere: how to get cgi, whats my time, whats up, status, rows, how to change, from api, c#api, api, perl change file, change column, api status, table perl, perl table, past number, connect api, transactions accounts, php account transactions, API document, change look, websites cgi list, php time table system, change field account, file api, time table system php

Om arbejdsgiveren:
( 115 bedømmelser ) Newark, United Kingdom

Projekt-ID: #295625