You said you have a binary that will do the delete..I then inferred that you were saying you had one that would do the delete without admin permissions (which is what Marek was complaining about).so I thought you were saying you had a solution for him..but now I guess you are saying you don't?
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: Tuesday, January 04, 2011 10:31 AM To: [email protected] Subject: Re: Deleting entry with api ** If you use the API you need permissions. The API adhere to the ARS permissions model (of course). Note again that you cannot inhibit filters. So, a filter could simply throw an error and abort an API delete. I use these (and Meta-Update) as a matter of convenience when problem solving, developing, etc. Cheers Ben From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: January-04-11 17:27 To: [email protected] Subject: Re: Deleting entry with api ** Ben, I'm curious. How have you written an API based program that deletes records without sufficient permissions? From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: Tuesday, January 04, 2011 8:51 AM To: [email protected] Subject: Re: Deleting entry with api ** We do have such a binary(binaries) the delete with the API. It's available in Windows and support ARS platforms. It is also relatively easy for you to make such a binary. Note that you cannot inhibit filters that fire on Delete with the API. I am currently considering marketing and publication options such as packaging it with the Meta-Update distribution or making them available separately. This consideration ranges to a set of binaries including a query tool, so you could say, query first, then delete. The binaries work something along the lines of: SthMqry -c schema query to return results count only SthMqry -n schema query to return results only SthMqry schema query to return results with field values on separate lines SthMqry -f schema query to return results with field values as a CSV for say, Excel SthMqry -S ";" schema query (specify CSV separator) SthMdel -q schema query to delete results of query And additionally to the SthMqry synopsis above, Meta-Query supports SQL queries. SthMqry -q sql_query issues an SQL query through the API; also supports -f Email me off-list if you're interested or want to know more. Happy New Year! Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:[email protected]> Ben.Chernys _AT_ softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marek B. Sent: January-04-11 16:00 To: [email protected] Subject: Deleting entry with api ** Hi listers, Is there any method to delete an entry in a custom form via java or dotnet api? Using a DeleteEntry method gives me no administrative permissions error, which is correct and I don't want to give such permissions. Also I don't want to create any extra workflow on server side. Is it feasible? regards, Marek _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
