SugarCRM not returning new entries after Posting to the Rest API
$10-30 USD
Completed
Posted over 10 years ago
$10-30 USD
Paid on delivery
We are using Zapier to move data from two online services.
When Zapier tries to get new entries, SugarCRM is returning older results.
I need you to fix SugarCRM to output the newest information.
This is what Zapier said in their email:
_________________________________________________________
We're POSTing a payload to the REST API at http://..... according to the documentation available here: [login to view URL]
Here is the raw data we POST:
rest_data=%5B%22e7dc4a8c11a096ad6e5c5e140b254405%22%2C+%22Contacts%22%2C+%22%22%2C+%22date_entered+DESC%22%2C+0%2C+%5B%22accept_status_id%22%2C+%22accept_status_name%22%2C+%22account_id%22%2C+%22account_name%22%2C+%22alt_address_city%22%2C+%22alt_address_country%22%2C+%22alt_address_postalcode%22%2C+%22alt_address_state%22%2C+%22alt_address_street%22%2C+%22alt_address_street_2%22%2C+%22alt_address_street_3%22%2C+%22assigned_user_id%22%2C+%22assigned_user_name%22%2C+%22assistant%22%2C+%22assistant_phone%22%2C+%22birthdate%22%2C+%22c_accept_status_fields%22%2C+%22campaign_id%22%2C+%22campaign_name%22%2C+%22created_by%22%2C+%22created_by_name%22%2C+%22date_entered%22%2C+%22date_modified%22%2C+%22deleted%22%2C+%22department%22%2C+%22description%22%2C+%22do_not_call%22%2C+%22email%22%2C+%22email1%22%2C+%22email2%22%2C+%22email_addresses_non_primary%22%2C+%22email_and_name1%22%2C+%22email_opt_out%22%2C+%22first_name%22%2C+%22full_name%22%2C+%22id%22%2C+%22invalid_email%22%2C+%22last_name%22%2C+%22lead_source%22%2C+%22m_accept_status_fields%22%2C+%22modified_by_name%22%2C+%22modified_user_id%22%2C+%22name%22%2C+%22opportunity_role%22%2C+%22opportunity_role_fields%22%2C+%22opportunity_role_id%22%2C+%22phone_fax%22%2C+%22phone_home%22%2C+%22phone_mobile%22%2C+%22phone_other%22%2C+%22phone_work%22%2C+%22primary_address_city%22%2C+%22primary_address_country%22%2C+%22primary_address_postalcode%22%2C+%22primary_address_state%22%2C+%22primary_address_street%22%2C+%22primary_address_street_2%22%2C+%22primary_address_street_3%22%2C+%22report_to_name%22%2C+%22reports_to_id%22%2C+%22salutation%22%2C+%22sync_contact%22%2C+%22title%22%5D%2C+%5B%5D%2C+50%2C+0%5D&input_type=JSON&method=get_entry_list&response_type=JSON
And here is the REST data pretty printed for convenience:
[
"Note the order_by inclusion, however, the response we're getting is in effectively random order (or is ordering by something different). The first thing I might try: see if you can log the SQL queries being made, is the ORDER BY being included? If yes, then MySQL might be messed up. If no, SugarCRM is being weird."
Hello Sir,
i want to work on it please give me all the details about that i will give you 100% output, i also done this kind of projects so don't worry about the work . waiting for your response thanks.