(BASIC MOCKUPS ATTACHED)
BUDGET : 1000 USD MAX
I currently have a system that receives data into a MySQL database using a HTTP post system.
Our partners post us data using http strings like this:
Using the format:
Partners can submit data to our DB. This DB then makes an API call to Mailchimp to insert the data into mailchimp.
Our DB can give several responses:
Anything else, not accepted.
2: Duplicate email
3: Invalid (invalid domain, domain doesnt exist, email on suppression list)
4: Other invalid details
- We need to check that the system is working correctly and what it is currently checking for in those 1,2,3,4 statuses. Invalid domain etc, other invalid details and so on.
Currently the system is just a basic system with no backend or management interface. We need to build a stats page, management page etc.
- We need to build a simple stats system where I can do the following:
- View partners based on PartnerID
This should be at a summary level in a table viewable in a web interface, with the option to export any of the data views into a csv file (full data, not the paginated version).
- Summary with date range selector
Number of leads sent by partner
Number of leads accepted
Number of leads rejected
We also need to be able to have a system that sends HTTP GET OR POST requests according to a certain pattern of URL.
The requests will be in a similar format to our URL. This should be viewable under - > Partners Outgoing
We should be able to select partner Live / Not Live
We should be able to choose GET or POST
We should be able to specify the format of their URL – and insert our data in the correct part of the URL.
When the partner is live, data that is received is parsed and then sent via the HTTP request to their system.
We should be able to view a list of the data sent to them, similar to the view of the data received, it should include the response code that is fed back.
We should be able to choose which INCOMING partner leads are sent to the OUTGOING partner. So for example INCOMING ID 006, 007 can be active for OUTGOING partner ID AAA.