I'd like to post to chatter on an opportunity record depending if that opportunity record meets a certain criteria. 

Ideally, I'd like to use python to do this, but have not been able to figure out how to do it. 

 

I'd like to pull all Opportunity IDs that have a task associated with a certain person. 

I've tried the following

Select ID from Opportunity where AccountID IN (Select AccountID From TASK WHERE CreatedBy.Name='Person' OR LastModifiedBy.Name='Person' )

But I get the following error 
ERROR at Row:1:Column:80 Entity 'TASK' is not supported for semi join inner selects"

Is there any work around to this

Hi all,

 

Thought I should announce here that I've written a Python library for the Chatter API, and released it under an MIT license:

 

https://github.com/nixmc/chatter/

 

It's heavily influenced by the awesome Python Twitter Tools library, which is a proven and robust library for the Twitter API. You can find more details on the Github page.

 

I hope others find this work useful, hit me up (@stevewinton on Twitter) with any questions or feedback.

 

Best,

Steve