Any document that lists web method calls for service connect?

Just to summarise the solution: it is possible to call the DynamicQueryService.ExecuteByIDParametrized() method and use the results, but you have to be careful.

By default the result will be returned to a result node with no further schema. Without further work this is useless. However examining the Activity log for the call will show the structure of the data inside that result node.
It goes something like this:

<result>
<anonymous>
...
...
...
</anonymous>
</result>

Copy this xml to a file and use this file with the schema utility, to create and import a schema into ESC.

Then in your mapping after the method call, map the result node of the call to the result node of your mapping output schema (or a message extension of course). Then use as normal in subsequent mapping steps.

The thing to realise is that the schema will be absolutely specific to the call itself, so a different schema for every BAQ and will change any time the result columns change.


--- In vantage@yahoogroups.com, "Alex Fiedler" <alex@...> wrote:
>
> Did you have any success with DynamicQuery and ESC? I am getting an error when using ExecuteByIDParametrized() about "unable to load response error invalid unicode character". I will have to try some of the other methods but it appears the result returned by the BAQ is somewhat amorphous i.e. does not have a defined structure and that ESC is not sure what to do with all that quoted XML.
>
>
>
> --- In vantage@yahoogroups.com, "pbparker" <scrumbus@> wrote:
> >
> > Yup, looks like DynamicQueryService is what I'm looking for. I don't want to manually use the BAQ export or schedule it in Epicor, I wanted to have SC do the retrieval and then transform/push the data elsewhere.
> >
> > Yeah, I had done the tracing but was looking to see if there was something else I had potentially missed in the documentation.
> >
> > Thanks though.
> >
> > --- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@> wrote:
> > >
> > > IF you are trying to just get the data into Service connect, yes the BAQ Export will work or register (in V8 DynamicQueryService), this way you can manipulate the query if need be.
> > >
> > > ________________________________
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
> > > Sent: Tuesday, February 28, 2012 10:09 AM
> > > To: vantage@yahoogroups.com
> > > Subject: RE: [Vantage] Any document that lists web method calls for service connect?
> > >
> > >
> > >
> > > For those other service connect users, what method do you use to find the right service for the right purpose?
> > > Tracing options
> > >
> > > I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.
> > >
> > > I am not sure what you are trying to do, but you can use the BAQ export to get a csv file and an input channel to bring it into Service Connect
> > > Or, you can use a BPM to somehow do that I hear, I have not tried that yet...
> > >
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of pbparker
> > > Sent: Tuesday, February 28, 2012 11:55 AM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Any document that lists web method calls for service connect?
> > >
> > > I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.
> > >
> > > I know I can register the web services with the WCF and then interrogate them with the WCF tester, but seems like a lot of work to register blindly objects to see if something will do what I want it to.
> > >
> > > I don't see anything that indicates plainly that it will return a BAQ result set. Only one that even looks close is BAQReport_RPRService.
> > >
> > > For those other service connect users, what method do you use to find the right service for the right purpose?
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.

I know I can register the web services with the WCF and then interrogate them with the WCF tester, but seems like a lot of work to register blindly objects to see if something will do what I want it to.

I don't see anything that indicates plainly that it will return a BAQ result set. Only one that even looks close is BAQReport_RPRService.

For those other service connect users, what method do you use to find the right service for the right purpose?
For those other service connect users, what method do you use to find the right service for the right purpose?
Tracing options

I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.

I am not sure what you are trying to do, but you can use the BAQ export to get a csv file and an input channel to bring it into Service Connect
Or, you can use a BPM to somehow do that I hear, I have not tried that yet...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
Sent: Tuesday, February 28, 2012 11:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Any document that lists web method calls for service connect?



I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.

I know I can register the web services with the WCF and then interrogate them with the WCF tester, but seems like a lot of work to register blindly objects to see if something will do what I want it to.

I don't see anything that indicates plainly that it will return a BAQ result set. Only one that even looks close is BAQReport_RPRService.

For those other service connect users, what method do you use to find the right service for the right purpose?



[Non-text portions of this message have been removed]
IF you are trying to just get the data into Service connect, yes the BAQ Export will work or register (in V8 DynamicQueryService), this way you can manipulate the query if need be.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Tuesday, February 28, 2012 10:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Any document that lists web method calls for service connect?



For those other service connect users, what method do you use to find the right service for the right purpose?
Tracing options

I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.

I am not sure what you are trying to do, but you can use the BAQ export to get a csv file and an input channel to bring it into Service Connect
Or, you can use a BPM to somehow do that I hear, I have not tried that yet...

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of pbparker
Sent: Tuesday, February 28, 2012 11:55 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Any document that lists web method calls for service connect?

I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.

I know I can register the web services with the WCF and then interrogate them with the WCF tester, but seems like a lot of work to register blindly objects to see if something will do what I want it to.

I don't see anything that indicates plainly that it will return a BAQ result set. Only one that even looks close is BAQReport_RPRService.

For those other service connect users, what method do you use to find the right service for the right purpose?

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Yup, looks like DynamicQueryService is what I'm looking for. I don't want to manually use the BAQ export or schedule it in Epicor, I wanted to have SC do the retrieval and then transform/push the data elsewhere.

Yeah, I had done the tracing but was looking to see if there was something else I had potentially missed in the documentation.

Thanks though.

--- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@...> wrote:
>
> IF you are trying to just get the data into Service connect, yes the BAQ Export will work or register (in V8 DynamicQueryService), this way you can manipulate the query if need be.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
> Sent: Tuesday, February 28, 2012 10:09 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Any document that lists web method calls for service connect?
>
>
>
> For those other service connect users, what method do you use to find the right service for the right purpose?
> Tracing options
>
> I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.
>
> I am not sure what you are trying to do, but you can use the BAQ export to get a csv file and an input channel to bring it into Service Connect
> Or, you can use a BPM to somehow do that I hear, I have not tried that yet...
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of pbparker
> Sent: Tuesday, February 28, 2012 11:55 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Any document that lists web method calls for service connect?
>
> I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.
>
> I know I can register the web services with the WCF and then interrogate them with the WCF tester, but seems like a lot of work to register blindly objects to see if something will do what I want it to.
>
> I don't see anything that indicates plainly that it will return a BAQ result set. Only one that even looks close is BAQReport_RPRService.
>
> For those other service connect users, what method do you use to find the right service for the right purpose?
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Did you have any success with DynamicQuery and ESC? I am getting an error when using ExecuteByIDParametrized() about "unable to load response error invalid unicode character". I will have to try some of the other methods but it appears the result returned by the BAQ is somewhat amorphous i.e. does not have a defined structure and that ESC is not sure what to do with all that quoted XML.



--- In vantage@yahoogroups.com, "pbparker" <scrumbus@...> wrote:
>
> Yup, looks like DynamicQueryService is what I'm looking for. I don't want to manually use the BAQ export or schedule it in Epicor, I wanted to have SC do the retrieval and then transform/push the data elsewhere.
>
> Yeah, I had done the tracing but was looking to see if there was something else I had potentially missed in the documentation.
>
> Thanks though.
>
> --- In vantage@yahoogroups.com, Dan Godfrey <dgodfrey@> wrote:
> >
> > IF you are trying to just get the data into Service connect, yes the BAQ Export will work or register (in V8 DynamicQueryService), this way you can manipulate the query if need be.
> >
> > ________________________________
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
> > Sent: Tuesday, February 28, 2012 10:09 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Any document that lists web method calls for service connect?
> >
> >
> >
> > For those other service connect users, what method do you use to find the right service for the right purpose?
> > Tracing options
> >
> > I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.
> >
> > I am not sure what you are trying to do, but you can use the BAQ export to get a csv file and an input channel to bring it into Service Connect
> > Or, you can use a BPM to somehow do that I hear, I have not tried that yet...
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of pbparker
> > Sent: Tuesday, February 28, 2012 11:55 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Any document that lists web method calls for service connect?
> >
> > I'm trying to find if there's a method to call a BAQ to get the data and pull it out to a document.
> >
> > I know I can register the web services with the WCF and then interrogate them with the WCF tester, but seems like a lot of work to register blindly objects to see if something will do what I want it to.
> >
> > I don't see anything that indicates plainly that it will return a BAQ result set. Only one that even looks close is BAQReport_RPRService.
> >
> > For those other service connect users, what method do you use to find the right service for the right purpose?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>