I am trying to return all merger and acquisition corporate events for Apple Inc. I have constructed this query using another developer page, as well as Eikons Excel formula build in.

Using:

symbol = 'AAPL.OQ'
names_list = ['TR.DealDate;TR.DealStatus;TR.DealAcquiror;TR.DealTarget;TR.DealType;TR.DealSynopsis; TR.DealAnnouncementDate;TR.DealPercentSought;TR.DealPercentOwned, ']
start_date = str(20100101)
end_date = str(20180312)
df, error = ek.get_data(symbol, names_list, {"SDate": start_date, "EDate": end_date})
df.sort_values('Date', ascending=False)

It appears to be returning very different results for what I can see in Eikon. By changing the RIC you can see more examples of incorrect returns.