Hi,

We need to be able to call execute a business rule that applies some fairly complex rules to an Opportunity and creates a new Opportunity from the original.  We need to call this from an external application and don't want to have to reproduce the business logic that's already in place in our Business Rule Method in App Architect.  Has anyone had any experience of executing a Business Rule Method from SData?

I've imported the package reference to SData into my project using Nuget and can query data as follows.  Here's a brief example:

ISDataService

svc =

new SDataService("http://webserver:5555/sdata/slx/dynamic/-/", "lee", ""

);

// Now create the request, passing in the ISDataService we created

// above

(svc);

// Tell it which kind of resource we want to access, in this case

// Contacts. Note, this needs to match the values on the SData tab

// of the entity in Application Architect

;

// This part is optional (without it we'd be getting ALL contacts).

// This is our where clause, or condition of which contacts we want.

// In this example we want all contacts whose last name starts with

// the value 'Ab'. We need to use the exact property name as defined

// in the entity (case-sensitive).

);

I know the above code is not relevant to what we need to do but I've included it to show the kind of things that we know how to do!  Does anyone have any code examples of how we can invoke a Business Rule Method?  Any pointers/documentation/code examples would be welcomed.

Regards

Daniel

Yes, you can.  The thing to keep in mind is that the rule will not have entity context as only scalars are allowed from SData calls.  So, the variable 'opportunity' in the BR below will be NULL when you call it from SData.  The workaround is to write a wrapper rule to call your rule that takes in the Opp ID as a string:

public static void MyRule( IOpportunity opportunity,  string OppId, out Boolean result)<br />{
    result = false;
    if (string.IsNullOrEmpty(OppId))
        return;
    IOpportunity o = Sage.Platform.EntityFactory.GetById<IOpportunity>(OppId);
    if (o == null)
        return;                
    o.OriginalComplexRule();
    result = true;
}

SDataServiceOperationRequest sreq = new SDataServiceOperationRequest(_SDataSvc)<br />{
    ResourceKind = "opportunities",
    OperationName = "MyRule"
};
sreq.Entry = new AtomEntry();
sreq.Entry.SetSDataPayload(
new SDataPayload
{
    ResourceName = "OppMyRule",
    Namespace = "http://schemas.sage.com/dynamic/2007",
    Values = {
        {"request",
            new SDataPayload {                                    
                Values = {                                        
                    {"OppId", LocalVariableWithOppId}
                }
            }                                                               
        }
    }
}
);
AtomEntry result = sreq.Create();
var res = (SDataPayload)result.GetSDataPayload().Values["response"];
bool bResult = res.Values["Result"].ToString().ToLower() == "true";
if (bResult)
    // Rule succeeded
else
    // Rule failed

Sweet!

Hi Mike,

That's brilliant.  Really appreciate your prompt response.  Your wrapper rule is pretty clever.  I've implemented this and it's nearly there I think.  I get the following error though and I'm quite sure how to resolve it:

"Invalid payload detected, expecting 'OpportunityMyRule' found 'http://schemas.sage.com/dynamic/2007:MyRule'."

It looks like the namespace in the payload doesn't match what's expected in the SDataServiceOperationRequest...

I've tried changing the namespace in the payload but no luck so far.

Any tips would be appreciated.

Cheers

Daniel

Just make sure to replace "MyRule" with whatever you have called the rule.

Hi Mike,

The 'MyRule' in my post was just to anonymise the code a bit.  The code actually looks like this and the error message is:

Invalid payload detected, expecting 'OpportunityCreateOppFromExisting' found 'http://schemas.sage.com/dynamic/2007:CreateOppFromExisting'." 

I'm not quite sure what I need to do with the namespaces to resolve this.

The full code is below:

        private void createOppFromExisting(string opportunityId)
        {
            ISDataService svc = new SDataService("http://servername:3333/sdata/slx/dynamic/-/", "admin", "");

            SDataServiceOperationRequest sreq = new SDataServiceOperationRequest(svc) { ResourceKind = "opportunities", OperationName = "CreateOppFromExisting"};
            sreq.Entry = new AtomEntry();
            sreq.Entry.SetSDataPayload(new SDataPayload
            {
                ResourceName = "CreateOppFromExisting", Namespace = "http://schemas.sage.com/dynamic/2007",
                Values =
                {
                    {"request",  new SDataPayload
                        { Values =
                            {
                                {"OppId", opportunityId}
                            }           
                        }                                                                      
                     }
                }
            });
            AtomEntry result = sreq.Create();
            var res = (SDataPayload)result.GetSDataPayload().Values["response"];
            bool bResult = res.Values["Result"].ToString().ToLower() == "true";
        }

Just to clarify, this occurs on AtomEntry result = sreq.Create();

Try setting the resourcename to "OpportunityCreateOppFromExisting".

Hi Daniel,

could you tell me, whether LaSpina's suggestion works, or not? Thanks for your help!

Even it's a bit late: the code works except for the last few lines (at least for me on 7.5.4).

The value "response" in the responsePayload does not contain another payload, but a SDataSimpleCollection. So the last lines should be something like:

AtomEntry entry = sreq.Create();
SDataPayload responsePayload = entry.GetSDataPayload();
if (responsePayload != null && responsePayload.Values["response"] != null)
    result = ((SDataSimpleCollection)responsePayload.Values["response"])[0].ToString().ToLower() == "true";