Forum Discussion

Adept

8 years ago

Community API V2 LiQL following query returning empty set

I am trying to retrieve the following data using the query returned in the user object. The query is SELECT * FROM users WHERE followers.id = 'XXXXX' where XXXXX is the user ID that is known to be ...

RobertT
8 years ago
wsurguy

You can create a proxy endpoint in studio which effectively performs the call in Freemarker using APIv2 and output the raw data in JSON, and you should be able to parse header data into the request using Freemarker as well, I can't see any problems doing that.

You'll need to pass any variables to the endpoint and sanitise them before performing the call which is easy to do and you should be able to pass those variables through the header request or alternatively as URL parameters.

The Freemarker Context Objects documentation for Lithium may help with this.

Adept

This is not in Studio. In Studio via the API browser it works on our stage instance.

I am using node.js to execute the call.

Boss

8 years ago

Would you mind going into a little more detail on how you're querying API v2 using NodeJS, I'm not quite sure but authentication may be playing a part.

If it is, you may want to look at creating an Endpoint in Studio as a proxy to retrieve the data for NodeJS.

wsurguy
Adept
8 years ago
Robert - I am passing the client-id in the header which seems to work for some calls but not for this one.
That may be the issue I am running into.

As for using an endpoint, will it require elevated privileges or would I be able to access by passing the client-id in the header?

Thanks for your response.
- RobertT
  Boss
  8 years ago
  wsurguy
  
  You can create a proxy endpoint in studio which effectively performs the call in Freemarker using APIv2 and output the raw data in JSON, and you should be able to parse header data into the request using Freemarker as well, I can't see any problems doing that.
  
  You'll need to pass any variables to the endpoint and sanitise them before performing the call which is easy to do and you should be able to pass those variables through the header request or alternatively as URL parameters.
  
  The Freemarker Context Objects documentation for Lithium may help with this.