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

     

Parshant's avatar
Parshant
Boss
6 years ago

PAULEM ,

Error you are facing is not about 'custom_tag' or 'custom_tags'.  Error is showing due to constraints, there is no constraint available with 'custom_tags.id', which means you can not use this in where clause. To your solution you can use 'custom_tags.text' to get the message.

See all related documents here for the message.