To get session ID for Lithium on Alteryx - read cookies to get the SSO - go to link below and
Look for the one titled !LithiumSSO
API endpoints for V1 and V2:
V1:
http://community.alteryx.com/restapi/vc
V2:
http://community.alteryx.com/api/2.0/search
chrome://settings/cookies/detail?site=alteryx.com&search=site
http://community.alteryx.com
1000
1000
2017-01-01
Full API URL
/api/2.0/search
Error
CommunityAPIRoot
page
Int32
4
0
page < [MaxPages]
page + 1
Paging
set query string
q = "SELECT
id,
author.id,
author.login,
board.id,
conversatio...
201
Cross Origin Error
A cross-origin request (CORs) header check has failed
301
Unexpected Error
302
Unsupported Error
An unsupported API method has been called
303
Resource Not Found
A resource cannot be found for a given URI
501
No Entity with Property
An entity with the given property cannot be located
502
Entity Create Failed
The create operation for the given entity failed unexpectedly
503
Entity Update Failed
The update operation for the given entity failed unexpectedly
504
Cannot Parse Required Entity
A required entity cannot be parsed from a request
601
Missing Query
A request is missing a LiQL query
602
Unidentified Collection
A LiQL query contains an undefined collection
603
Invalid Query Syntax
A LiQL query contains invalid syntax
604
Query Failed Validation
Validation failed in a LiQL query
API 2 Error Codes
Allow
([page]) <= ([totalMessageCount]/[page_size])
Custom
=
True
fixed
2018-07-20 17:55:22
0
2018-07-20 17:55:22
2018-07-20 17:55:22
Remove extra calls
([page]) <= ([totalMessageCount]/[page_size])
Do not include the RestAPI root - only the community URL Root (e.g. http://community.alteryx.com)
#1
ExpAll
not(contains([CommunityAPIRoot],'restapi'))
too many / at end of community URL root
#1
ExpAll
not(right(trim([CommunityAPIRoot]),1)='/')
API 2 included in URL
#1
ExpAll
not(
contains([CommunityAPIRoot],'api/') or
contains([CommunityAPIRoot],'/api')
)
http:// or https:// needed
#1
ExpAll
contains(lowercase([CommunityAPIRoot]),'https://') or
contains(lowercase([CommunityAPIRoot]),'http://')
Error Checks
Do not include the RestAPI root - only the community URL Root (e.g. http://community.alteryx.com)
too many / at end of community URL root
API 2 included in URL
http:// or https:// needed
q = [q] + " LIMIT " + tostring([page_size]) + ' OFFSET ' + tostring([page]*[page...
Messages
M
set query string
q3_totalCount = "SELECT count(*)
FROM messages
Where
board.id = 'weeklychalle...
Unique: JSON_Name
C:\Users\seanb\AppData\Local\Temp\Engine_5692_4521af944a5f41db8f6d38a07928e2e0_\Engine_17072_44519f6b75b042b5b1be70a203f4e7aa_.yxdb
Single
Profile
C:\Users\seanb\AppData\Local\Temp\Engine_5692_4521af944a5f41db8f6d38a07928e2e0_\Engine_17072_fb834eefafb04c60ad671998d716a92f_.yxdb
Single
Profile
Container 383
Last
Error
High
False
"Error on API: HTTP Code: " + [message]
Basic Processing
DownloadData
JSON_Name
ParseComplex
Warn
format_Matched
Parse:
data.items.(\d+)
JSON_Name
Replace
Warn
format_Matched
Contains([JSON_Name],"data.items")
Simple
Contains
JSON_Name
True
fixed
2018-07-20 19:02:31
0
data.items
2018-07-20 19:02:31
2018-07-20 19:02:31
Contains([JSON_Name],"data.items")
MsgIDTemp
New Field
Int32
4
NULL
if isnull([MsgIDTemp]) or [MsgIDTemp]='' then
[Row-1:MsgIDTe...
User Details
,
JSON_Name
JSON_Field_Name
ColName
FindAny
Append
id
id
author.id
author.id
author.login
author.login
board.id
board.id
conversation.id
conversation.id
topic.id
topic.id
subject
subject
post_time
post_time
can_accept_solution
can_accept_solution
conversation.solved
conversation.solved
is_solution
is_solution
view_href
view_href
conversation.view_href
conversation.view_href
topic.view_href
topic.view_href
current_revision.id
current_revision.id
current_revision.last_edit_time
current_revision.last_edit_time
!IsEmpty([ColName])
Simple
IsNotEmpty
ColName
True
fixed
2018-06-10 14:20:09
0
2018-06-10 14:20:09
2018-06-10 14:20:09
!IsEmpty([ColName])
Contains([JSON_Name],"user_badges.items.")
Simple
Contains
JSON_Name
True
fixed
2018-07-21 21:50:49
0
user_badges.items.
2018-07-21 21:50:49
2018-07-21 21:50:49
Contains([JSON_Name],"user_badges.items.")
cleanup fields - current_revision_last_edit_time
current_revision_last_edit_time = Replace([current_revision_last_edit_time], 'T'...
cleanup fields - post_time
post_time = Replace([post_time], 'T', ' ')
post_time = left([post_time],19)
post...
QueryBoards
FullURL
String
65001
GET
Compose
10
600
[IsErrorResponse] = 1
Simple
IsTrue
IsErrorResponse
True
fixed
2018-07-20 12:27:41
0
2018-07-20 12:27:41
2018-07-20 12:27:41
[IsErrorResponse] = 1
Message Count
FullURL
String
65001
GET
Compose
2
600
DownloadData
[IsErrorResponse] = 1
Simple
IsTrue
IsErrorResponse
True
fixed
2018-07-20 12:27:41
0
2018-07-20 12:27:41
2018-07-20 12:27:41
[IsErrorResponse] = 1
[JSON_Name] = "data.count"
Simple
=
JSON_Name
True
fixed
2018-07-20 17:52:25
0
2018-07-20 17:52:25
2018-07-20 17:52:25
data.count
[JSON_Name] = "data.count"
add in 10% just in-case
API Call Errors
Last
Error
High
False
Interface
CommunityRoot
DOP_Query
JSON Query Errors
DownloadData
[JSON_Name] in ("status","message", "data.size")
Custom
=
JSON_Name
True
fixed
2018-07-20 12:38:14
0
status
2018-07-20 12:38:14
2018-07-20 12:38:14
[JSON_Name] in ("status","message", "data.size")
,
[status] != "success"
Simple
!=
status
True
fixed
2018-07-20 12:43:27
0
success
2018-07-20 12:43:27
2018-07-20 12:43:27
[status] != "success"
Ignore
All
ByName
tonumber([data_size]) > 0
Custom
>
data_size
True
fixed
2018-07-20 16:04:51
0
0
2018-07-20 16:04:51
2018-07-20 16:04:51
empty stats
tonumber([data_size]) > 0
API Call Errors
Last
Error
High
False
Horizontal
Question
CommunityRoot
Question
Numeric Up Down (306)
Question
Numeric Up Down (307)
Question
DOP_Query
Question
Macro Output (366)
LithiumMessages
NoCondition
(Always Run)
Dynamic
{{INPUT}}
241/Data/r[1]/c[1]
Update Cell
Expression
row 1
column 1
UpdateValue
Simple
241/Data/r/c[3]
UpdateValue
Simple
241/Data/r/c[2]
UpdateValue
Simple
282/numConnections
UpdateValue
Simple
292/numConnections
Tab
Questions
Tab (17)
TextBox
Community root URL
CommunityRoot
http://community.alteryx.com
NumericUpDown
Page Size (number of rows at once
Numeric Up Down (306)
NumericUpDown
Total number of pages to retrieve
Numeric Up Down (307)
NumericUpDown
Degree of Parallel Query
DOP_Query
MacroOutput
Macro Output (366)
Macro Output (366)
Macro