khill
Mentor
Joined 9 years ago
User Profile
User Widgets
Contributions
Deleted Field on API V1 or V2?
Hi everyone, Is there a field value I can call via API that indicates if a post is deleted? I perform a daily pull of our messages API data and upload into our reporting database (catches posts back a week or so and adds new posts to the database and replaces any posts where data has changed). Every once and awhile a topic returns as "No Reply" in my metrics, but this is because the post was subsequently deleted by the user. Hoping to find some type of flag value so I can filter these out of our metrics if possible. Thanks, KateSolved187Views0likes3CommentsCustom Tag Parameter in APIV2 GET call?
Hi everyone, Just want to make sure I am not missing anything obvious here. Is there a way to call messages and include a custom_tag.text field? I see that you can constraint the APIv2 calls by custom_tag.text, but not that you can add it into the call fields. Going for something like this: SELECT id, custom_tag.text WHERE post_time > [yesterday] Thanks in advance for the help! KateSolved171Views1like2CommentsRe: REST API V2 - Query email from users returns null value
Ah okay so passing the client ID was not enough to authenticate as I was hoping! (I've had troubles with the OAuth process so am trying to avoid it :smileyhappy:). Thanks to you both and I will proceed with the above suggestions! Kate214Views0likes0CommentsREST API V2 - Query email from users returns null value
Hi everyone, I am trying to make an API v2 call to return a list of user IDs and their email addresses. When I make the call the login returns correctly, but email field returns with no data. Any ideas? Thanks! Kate Example LiQL: SELECT login, email FROM users ORDER BY registration_data.registration_time DESC I am using the standard V2 link format: https://api.lithium.com/community/2.0/[mycommunity]/search?q=[LiQL query]&client_id=[clientid] Sample Results: "data" : { "type" : "users", "list_item_type" : "user", "size" : 2000, "items" : [ { "type" : "user", "login" : "uid1", "email" : "" }, { "type" : "user", "login" : "uid2", "email" : "" }, { "type" : "user", "login" : "uid3", "email" : ""Solved232Views0likes3CommentsRe: New Board Data from API Not Returning?
Hi ttadej, Thanks for your suggestion - I couldn't find the new board was restricted to any groups. Also, when I query using the same login and credentials for the specific board id the API returns that data (just not when I query "all" boards). Very strange! Any other ideas? (maybe this is a question for a KhorosSFDC ticket instead - not sure) Thanks again! Kate102Views0likes0CommentsRe: New Board Data from API Not Returning?
Hi nehaSharma - thank you for your quick reply and troubleshooting ideas! So this is what is so odd, I can confirm that: 1) boards are not hidden via the individual pull as both boards return <hidden>false</hidden> 2) general pull is less than 100 records as size returns as <list_item_type>board</list_item_type> <size>58</size> Any other ideas I might be missing?117Views0likes2CommentsNew Board Data from API Not Returning?
Hi everyone, I am passing a very basic API call every month to capture any changes to our board metadata. https://api.lithium.com/community/2.0/[tenantid]/search?q=SELECT%09*%20FROM%20boards%20LIMIT%201000&client_id=[clientID]&api.pretty_print=true&format=xml LiQL query = SELECT * FROM boards LIMIT 100 We added a couple of new boards over the last month, but these new board IDs are not returning in my API call. However, I can call the board individually and the data returns correctly for this new board: https://api.lithium.com/community/2.0/[tenantid]/search?q=SELECT%09*%20FROM%20boards%20WHERE%20id%20%3D%20%27dspip_tools%27%20LIMIT%20100&client_id=[clientid]&api.pretty_print=true&format=xml LiQL query = SELECT * FROM boards WHERE id = 'dspip-tools' LIMIT 100 Any ideas why the more general call is not working? I can confirm it is returning updated info for the previously existing boards (i.e. title, description, etc.) just not returning the new board data.121Views0likes4CommentsRe: Bulk Kudos by Kudo Given Date Range and Message ID
Hi TariqHussain, Thanks (as always) for your help, I am not sure what I would do without you! Okay so with your guidance I have gotten to the LiQL call that provides message ID and sum of kudos which gets me pretty close to what I need. SELECT kudos.sum(weight), id from messages Trying to think of some work around ideas for getting more kudo info... there isn't a way to add kudo ID to this call is there? I don't think there is, but just in case!218Views0likes1Comment