Method:API Q&A

Re: Simple SQL call

Method_David — Tue, 25 Sep 2012 13:52:14 GMT

Hi Dominic Riccetti,

We don't allow table join queries via the API. I'll put in a suggestion about allowing this in the future.

To accomplish what you are trying to do you need to link the tables first and then query the resulting table via the API.

I'm gonna point you at the following http://www.methodintegration.com/cs/forums/p/381/1191.aspx#1191 and http://www.methodintegration.com/cs/forums/p/3321/12712.aspx#12712 both posts discuss the linking process

Dave

Simple SQL call

Dominic Riccetti — Sat, 22 Sep 2012 16:27:57 GMT

Hello,

I am trying to do this very simple SQL call through through the API:

SELECT table1.col1, table1.col2, table2.col1 FROM table1 INNER JOIN table2 ON table1.col5 = table2.col5 WHERE table1.col4='something'

I am finding this rather difficult, so I tried to create a custom table in Method which links these two tables for me, also didn't work as expected. How can I accomplish this?

Thank you,

Dominic