hmLoadTopic({
hmKeywords:"",
hmTitle:"GetTable",
hmDescription:"Returns the query result in a relational table format.",
hmPrevLink:"lk_lkproperties-dict-mode.html",
hmNextLink:"lk_gettable-dict-mode.html",
hmParentLink:"lk_crud-operations.html",
hmBreadCrumbs:"<a href=\"lk_linkarws-operations.html\">LinkarWS Operations<\/a> &gt; <a href=\"lk_crud-operations.html\">CRUD Operations<\/a>",
hmTitlePath:"LinkarWS Operations > CRUD Operations > GetTable",
hmHeader:"<h1 class=\"p_Heading1\" style=\"page-break-after: avoid;\"><span class=\"f_Heading1\">GetTable<\/span><\/h1>\n\r",
hmBody:"<p class=\"p_Normal\">Returns the query result in a relational table format.<\/p>\n\r<p class=\"p_Normal\">This version of GetTable is used to obtain queries of the LKSCHEMAS schema type. <\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-weight: bold;\">GET<\/span>: api\/v1\/<span style=\"font-weight: bold;\">&lt;apiresource&gt;<\/span>\/crud\/GetTable\/<span style=\"font-weight: bold;\">&lt;filename&gt;<\/span><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\" style=\"text-indent: 0; padding-left: 0.8125rem; margin-left: 0;\"><span class=\"f_Normal\" style=\"font-family: Arial,\'Lucida Sans Unicode\',\'Lucida Grande\',\'Lucida Sans\';display:inline-block;width:0.8125rem;margin-left:-0.8125rem\">&#8226;<\/span><span style=\"font-style: italic;\">&lt;apiresource&gt;<\/span> ApiResource name. e.g. <span style=\"font-style: italic;\">apidemo<\/span>.<br \/>\n\r<span style=\"font-style: italic;\">&nbsp;<\/span><\/p><p class=\"p_Normal\" style=\"text-indent: 0; padding-left: 0.8125rem; margin-left: 0;\"><span class=\"f_Normal\" style=\"font-family: Arial,\'Lucida Sans Unicode\',\'Lucida Grande\',\'Lucida Sans\';display:inline-block;width:0.8125rem;margin-left:-0.8125rem\">&#8226;<\/span><span style=\"font-style: italic;\">&lt;filename&gt;<\/span> File or table name defined in Linkar Schemas. Table notation is: MainTable[.MVTable[.SVTable]]<br \/>\n\r<span style=\"font-style: italic;\">e.g. api\/v1\/<\/span><span style=\"font-style: italic; font-weight: bold;\">apidemo<\/span><span style=\"font-style: italic;\">\/crud\/<\/span>GetTable<span style=\"font-style: italic;\">\/<\/span><span style=\"font-style: italic; font-weight: bold;\">LK.CUSTOMERS<\/span><\/p><p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-size: 1.09rem; font-weight: bold;\">Parameters<\/span><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 0 0;\"><table class=\"argumentos\" >\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">select_clause<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">string<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">Statement fragment specifies the selection condition. For example WITH CUSTOMER = \'1\'<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">sort_clause<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">string<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">Statement fragment specifies the selection order. If there is a selection rule Linkar will execute a SSELECT, otherwise Linkar will execute a SELECT. For example BY CUSTOMER<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">dict_clause<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">string<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">Space-delimited list of dictionaries to read. If this list is not set, all fields are returned. For example CUSTOMER DATE ITEM. In NONE mode you may use the format LKFLDx where x is the attribute number.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">row_properties<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">First row contains property names.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">only_visibles<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">Use only Visible Schemas and Properties.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">use_property_names<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">Use Properties and Table names.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">row_headers<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">string<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">Include headings in first row MAINLABEL (main headings), SHORTLABEL (short label headings), and NONE (without headings).<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">repeat_values<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">Repeat common atributes in MV and SV groups.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">calculated<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">Return the resulting values from the calculated dictionaries.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">apply_conversion<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">Execute Conversions: With Dictionaries, conversion defined in the dictionary. With Schemas conversions defined in Linkar Schemas.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">apply_format<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">Execute Formats. With Dictionaries, formats defined in the dictionary. With Schemas formats defined in Linkar Schemas.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">pagination<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">boolean<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">Indicates if pagination is being used or not.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">reg_page<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">integer<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">In case of pagination it indicates the page number to obtain. Must be greater than 0.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">num_page<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">integer<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">In case of pagination it indicates the page number to obtain. Must be greater than 0.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem;\"><p class=\"p_Normal\">custom_vars<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem;\"><p class=\"p_Normal\">string<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem;\"><p class=\"p_Normal\">This is a free text field to send in the transaction. If not empty, subroutine SUB.LK.MAIN.CONTROL.CUSTOM will be called. Add custom code to that subroutine to define special behaviours for some or all transactions.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<tr class=\"argumentos\">\n\r<td class=\"argumentos\" style=\"width:13.9375rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">svr_timeout<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:5.5000rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">integer<\/p>\n\r<\/td>\n\r<td class=\"argumentos\" style=\"width:49.5625rem; background-color:#CCFFFF;\"><p class=\"p_Normal\">This is the maximum time in seconds that the client will wait for a response. Use 0 for no timeout.<\/p>\n\r<\/td>\n\r<\/tr>\n\r<\/table>\n\r<\/div>\n\r<p class=\"p_Normal\"><span style=\"font-size: 0.91rem; font-style: italic;\">(*) Mandatory<\/span><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-size: 1.09rem; font-weight: bold;\">Request Body<\/span><\/p>\n\r<p class=\"p_Normal\">Unused<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-size: 1.09rem; font-weight: bold;\">Responses<\/span><\/p>\n\r<p class=\"p_Normal\">On all kind of responses, an <span style=\"font-style: italic;\">ERROR<\/span> tag will list all possible errors during execution of the operation. This tag includes <span style=\"font-style: italic;\">CODE<\/span> tag with the error codes and <span style=\"font-style: italic;\">MESSAGE<\/span> tag with messages of each error.<\/p>\n\r<p class=\"p_Normal\">In responses of type &quot;text\/plain&quot; (LkString MV), error codes and messages are separated by multivalue marks.<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic; font-weight: bold;\">application\/json<\/span><\/p>\n\r<p class=\"p_Normal\">This image shows an example of running an operation in the <span style=\"font-style: italic;\">LK.CUSTOMERS <\/span>file. &nbsp;<\/p>\n\r<p class=\"p_Normal\">In order to avoid a large example, <span style=\"font-weight: bold;\">select clause<\/span> has been defined with the value “WITH ID = ’10’ ID = ‘11’” and the rest of parameters have their default values. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><img style=\"margin:0;width:30.0000rem;height:24.1875rem;border:none\" src=\".\/images\/json_response_example2.png\"\/><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">Below is displayed the operation result. The complete content of the response is inside the <span style=\"font-style: italic;\">TABLE<\/span> node. In this node, the separator between fields is tab (ASCII 9) and the rows separation is vertical tab (ASCII 11).<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">{ &quot;TABLE&quot;: &quot;LK.CUSTOMERS\\tCustomer ID\\tCustomer Name\\tAddress\\tPhone\\u000b11\\t11\\tCUSTOMER 11\\tADDRESS 11\\t444 - 444 - 011\\u000b10\\t10\\tCUSTOMER 10\\tADDRESS 10\\t444 - 444 - 010&quot; }<\/span><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic; font-weight: bold;\">application\/xml<\/span><\/p>\n\r<p class=\"p_Normal\">This image shows an example of running an operation in the <span style=\"font-style: italic;\">LK.CUSTOMERS <\/span>file. &nbsp;<\/p>\n\r<p class=\"p_Normal\">In order to avoid a large example, <span style=\"font-weight: bold;\">select clause<\/span> has been defined with the value “WITH ID = ’10’ ID = ‘11’” and the rest of parameters have their default values. &nbsp; &nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><img style=\"margin:0;width:30.0000rem;height:24.0625rem;border:none\" src=\".\/images\/xml_response_example2.png\"\/> &nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">Below is displayed the operation result, formatted to read it more clearly.<\/p>\n\r<p class=\"p_Normal\"> Inside <span style=\"font-style: italic;\">CDATA<\/span> node, the separator between fields is tab (ASCII 9) and the rows separation is vertical tab (ASCII 11).<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">&lt;GETTABLE&gt;<\/span><\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">&lt;TABLE&gt;&lt;![CDATA[LK.CUSTOMERS &nbsp; &nbsp; &nbsp; &nbsp;Customer ID &nbsp; &nbsp; &nbsp; &nbsp;Customer Name &nbsp; &nbsp; &nbsp; &nbsp;Address &nbsp; &nbsp; &nbsp; &nbsp;Phone<\/span><\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">11 &nbsp; &nbsp; &nbsp; &nbsp;11 &nbsp; &nbsp; &nbsp; &nbsp;CUSTOMER 11 &nbsp; &nbsp; &nbsp; &nbsp;ADDRESS 11 &nbsp; &nbsp; &nbsp; &nbsp;444 - 444 - 011<\/span><\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">10 &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp;CUSTOMER 10 &nbsp; &nbsp; &nbsp; &nbsp;ADDRESS 10 &nbsp; &nbsp; &nbsp; &nbsp;444 - 444 - 010]]&gt;<\/span><\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">&lt;\/TABLE&gt;<\/span><\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">&lt;\/GETTABLE&gt;<\/span><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic; font-weight: bold;\">text\/plain<\/span><\/p>\n\r<p class=\"p_Normal\">This image shows an example of running an operation in the <span style=\"font-style: italic;\">LK.CUSTOMERS <\/span>file. &nbsp;<\/p>\n\r<p class=\"p_Normal\">In order to avoid a large example, <span style=\"font-weight: bold;\">select clause<\/span> has been defined with the value “WITH ID = ’10’ ID = ‘11’” and the rest of parameters have their default values. &nbsp; &nbsp;<\/p>\n\r<p class=\"p_Normal\">This response is a chain of characters structured in sections, named &quot;LkString&quot;.<\/p>\n\r<p class=\"p_Normal\">For more information about the different tags in this response, <a href=\"lk_text_plain.html\" class=\"topiclink\">click here<\/a>.<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><img style=\"margin:0;width:30.0000rem;height:23.5000rem;border:none\" src=\".\/images\/text_response_example3.png\"\/><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">Below is displayed the operation result, formatted to read it more clearly.<\/p>\n\r<p class=\"p_Normal\"> Inside <span style=\"font-style: italic;\">CDATA<\/span> node, the separator between fields is tab (ASCII 9) and the rows separation is vertical tab (ASCII 11).<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\"><span style=\"font-style: italic;\">LK.CUSTOMERS &nbsp; &nbsp; &nbsp; &nbsp;Customer ID &nbsp; &nbsp; &nbsp; &nbsp;Customer Name &nbsp; &nbsp; &nbsp; &nbsp;Address &nbsp; &nbsp; &nbsp; &nbsp;Phone<\/span><\/p>\n\r<p class=\"p_Normal\"><span style=\"width:3.0000rem;display:inline-block\">&nbsp;<\/span><span style=\"font-style: italic;\">11 &nbsp; &nbsp; &nbsp; &nbsp;11 &nbsp; &nbsp; &nbsp; &nbsp;CUSTOMER 11 &nbsp; &nbsp; &nbsp; &nbsp;ADDRESS 11 &nbsp; &nbsp; &nbsp; &nbsp;444 - 444 - 011<\/span><\/p>\n\r<p class=\"p_Normal\"><span style=\"width:3.0000rem;display:inline-block\">&nbsp;<\/span><span style=\"font-style: italic;\">10 &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp;CUSTOMER 10 &nbsp; &nbsp; &nbsp; &nbsp;ADDRESS 10 &nbsp; &nbsp; &nbsp; &nbsp;444 - 444 - 010<\/span><\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r<p class=\"p_Normal\">&nbsp;<\/p>\n\r"
})
