Forum Discussion

PAULEM's avatar
PAULEM
Advisor
6 years ago

Bug report - LiQL JSON response

In the API Browser (STUDIO) I entered SELECT * FROM custom_tags WHERE messages.id = '2867' This returned a JSON response: { "status" : "success", "message" : "", "http_code" : 200, "data" ...
  • VikasB's avatar
    VikasB
    6 years ago

    PAULEM 

    Here is something Lithium needs to heads up to correct the error text. Actually, the constraint is there in the API but unfortunately, custom_tags.text is not working with id.  You can pass the tag's key value instead of id. You can get the tag key at the edit screen of the custom tag. See here https://prnt.sc/mi84fu
    Like this

    SELECT * FROM messages WHERE custom_tags.text = 'custom.tag.value'


    But if you want to play with tag id only then you have to go with V1 API

    http://community.com/restapi/vc/posts/for/metadata/id/1046/value/true

     

VikasB's avatar
VikasB
Boss
6 years ago

PAULEM 

Here is something Lithium needs to heads up to correct the error text. Actually, the constraint is there in the API but unfortunately, custom_tags.text is not working with id.  You can pass the tag's key value instead of id. You can get the tag key at the edit screen of the custom tag. See here https://prnt.sc/mi84fu
Like this

SELECT * FROM messages WHERE custom_tags.text = 'custom.tag.value'


But if you want to play with tag id only then you have to go with V1 API

http://community.com/restapi/vc/posts/for/metadata/id/1046/value/true

 

  • PAULEM's avatar
    PAULEM
    Advisor
    6 years ago

    Thanks VikasB 

    Your snippet of advice is GOLD - just what I needed to do what I want to do!  I reported this bug to highlight this error and didn't expect an answer so thank you (and Parshant) very much for looking at this.

    Cheers, PaulM