<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article Using Qlik Application Automation to add users into spaces in Qlik Sense Documents</title>
    <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/ta-p/1896887</link>
    <description>&lt;P&gt;During a workshop, the most tedious part is to assign a QlikCloud user into the workshop space.&amp;nbsp; With &lt;LI-PRODUCT title="Qlik Application Automation" id="qlikApplicationAutomation"&gt;&lt;/LI-PRODUCT&gt;&amp;nbsp;, this process can be automated from the creation of the space to the assignment of the user into the specific space.&lt;/P&gt;&lt;P&gt;First, I created a google sheet that contains the list of users email, and 1 sheet correspond to 1 workshop.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_8-1645684631968.png" style="width: 507px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72961i08C2A55272A0633E/image-dimensions/507x169?v=v2" width="507" height="169" role="button" title="Edy_Tan_8-1645684631968.png" alt="Edy_Tan_8-1645684631968.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I used the List Sheets Of Spreadsheet block to list out all the sheets within this workbook&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_0-1645683722535.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72949iFDCA66F155B0A35D/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Edy_Tan_0-1645683722535.png" alt="Edy_Tan_0-1645683722535.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Then I used the Condition block to check whether the sheet is prefix with *.&amp;nbsp; This provide a mechanism to skip any sheet by renaming the sheet.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_1-1645683877592.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72950i25715FB06C2916C7/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Edy_Tan_1-1645683877592.png" alt="Edy_Tan_1-1645683877592.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;If it is not prefix with *, the Create Space block will create a space for each sheet using the name of the sheet.&amp;nbsp; You will need to set the type of share and most importantly, set on error to ignore and continue automation and ignore errors.&amp;nbsp; This will ignore this block when the space has already been created.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_2-1645683955849.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72951i7980BB67EF1FCF36/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Edy_Tan_2-1645683955849.png" alt="Edy_Tan_2-1645683955849.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Once the space is created, the Search Spaces block is used to retrieve the ID of the space as the space assignment is by the ID&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_3-1645684138700.png" style="width: 310px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72952i25F9DF699A9E7875/image-dimensions/310x110?v=v2" width="310" height="110" role="button" title="Edy_Tan_3-1645684138700.png" alt="Edy_Tan_3-1645684138700.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Next, the Get Data From Sheet With Headers block is used to retrieve the list of users email from the google sheet&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_5-1645684277015.png" style="width: 342px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72957iE8E8CA3C9CFE300F/image-dimensions/342x106?v=v2" width="342" height="106" role="button" title="Edy_Tan_5-1645684277015.png" alt="Edy_Tan_5-1645684277015.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;For each user email, the Search Users block is used to retrieve the ID based on the email address.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_4-1645684262183.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72956iFA08F57789B99AFA/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Edy_Tan_4-1645684262183.png" alt="Edy_Tan_4-1645684262183.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;With both the Space ID and User ID, the Add Member To Space block is used to assign the user into the space.&amp;nbsp; Note the type of roles to assign to the user and the type of member.&amp;nbsp; Also set the on error to ignore and continue automation and ignore errors in case the user has not signed up yet.&amp;nbsp; This will ignore this user and move to the next user.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_6-1645684400145.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72958i56F7CC26646C8147/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Edy_Tan_6-1645684400145.png" alt="Edy_Tan_6-1645684400145.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The following is the entire flow of the Qlik Application Automation&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_7-1645684527069.png" style="width: 636px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72959i3EC93A1DAF971626/image-dimensions/636x588?v=v2" width="636" height="588" role="button" title="Edy_Tan_7-1645684527069.png" alt="Edy_Tan_7-1645684527069.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;This can then be scheduled to run everyday and possibly more frequently just before the start of the workshop.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Edy_Tan_0-1645684954191.png" style="width: 400px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/72962i30A1839EAEDB9F53/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Edy_Tan_0-1645684954191.png" alt="Edy_Tan_0-1645684954191.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 03 Nov 2022 06:11:44 GMT</pubDate>
    <dc:creator>Edy_Tan</dc:creator>
    <dc:date>2022-11-03T06:11:44Z</dc:date>
    <item>
      <title>Using Qlik Application Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/ta-p/1896887</link>
      <description>&lt;P&gt;[Paragraph format. Descriptive text here. See &lt;A href="https://confluence.qliktech.com/display/QLSU/Chapter+0%3A++Article+Quick+Reference+Guide" target="_blank" rel="noopener"&gt;Content Guidelines&lt;/A&gt; for details. You can remove sections that are not needed for your article. If subheaders are needed, use heading 3 or heading 4 formats.]&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;H4&gt;Environment&lt;/H4&gt;&lt;UL&gt;&lt;LI&gt;[List Product Name and Version]&lt;/LI&gt;&lt;LI&gt;[List Product Name and Version]&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.&lt;/P&gt;&lt;H3&gt;Related Content [can be removed if not necessary]&lt;/H3&gt;&lt;P&gt;[Paragraph format. Link to related content, such as articles, community posts, Help articles, etc...]&lt;/P&gt;</description>
      <pubDate>Thu, 03 Nov 2022 06:11:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/ta-p/1896887</guid>
      <dc:creator>Edy_Tan</dc:creator>
      <dc:date>2022-11-03T06:11:44Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1913570#M5492</link>
      <description>&lt;P&gt;Would you know why the Add member to space fails in my case? I inputted a correct userid.&lt;BR /&gt;The error message doesn't tell much.&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="add to space error.png" style="width: 651px;"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/76060iBA9AECB1B05CF985/image-size/large?v=v2&amp;amp;px=999" role="button" title="add to space error.png" alt="add to space error.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Sun, 03 Apr 2022 13:30:33 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1913570#M5492</guid>
      <dc:creator>msan</dc:creator>
      <dc:date>2022-04-03T13:30:33Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1916193#M5501</link>
      <description>&lt;P&gt;under the add member to space block the information required are:&lt;/P&gt;&lt;P&gt;Space Id - make sure you reference the space ID, I used Search Spaces to search the space name to return the Item&amp;gt;Id&lt;/P&gt;&lt;P&gt;Assignee Id - make sure you reference the user ID, I used Search Users block to search the user email address to return the Item&amp;gt;Id&lt;/P&gt;&lt;P&gt;Roles - the roles can be from managed spaces or shared spaces, for e.g. for shared spaces I used,&amp;nbsp;["producer","consumer","dataconsumer"]&lt;/P&gt;&lt;P&gt;Another possibility is the user might already been assigned to the space, either check before assigning or under settings set on error to ignore and continue automation&lt;/P&gt;</description>
      <pubDate>Fri, 08 Apr 2022 09:06:24 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1916193#M5501</guid>
      <dc:creator>Edy_Tan</dc:creator>
      <dc:date>2022-04-08T09:06:24Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1916600#M5502</link>
      <description>&lt;P&gt;Thanks, will check the last &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Sun, 10 Apr 2022 10:56:22 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1916600#M5502</guid>
      <dc:creator>msan</dc:creator>
      <dc:date>2022-04-10T10:56:22Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1931001#M5530</link>
      <description>&lt;P&gt;Thank you so much Edy!&lt;/P&gt;</description>
      <pubDate>Mon, 16 May 2022 10:59:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1931001#M5530</guid>
      <dc:creator>KWF_JKassing</dc:creator>
      <dc:date>2022-05-16T10:59:27Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1967410#M5603</link>
      <description>&lt;P&gt;Thanks,&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47366"&gt;@Edy_Tan&lt;/a&gt;&amp;nbsp;! How would I go about checking to see if a user is already assigned to a space?&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 10 Aug 2022 22:57:56 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1967410#M5603</guid>
      <dc:creator>jackm75</dc:creator>
      <dc:date>2022-08-10T22:57:56Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1967427#M5604</link>
      <description>&lt;P&gt;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6726"&gt;@jackm75&lt;/a&gt;&amp;nbsp; what I did is when I add the user to the space,&amp;nbsp;&lt;SPAN&gt;under settings set on error to ignore and continue automation.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 11 Aug 2022 01:01:53 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/1967427#M5604</guid>
      <dc:creator>Edy_Tan</dc:creator>
      <dc:date>2022-08-11T01:01:53Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Application Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2056814#M5702</link>
      <description>&lt;P&gt;Great job&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47366"&gt;@Edy_Tan&lt;/a&gt; &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;BR /&gt;Did you invite new users from the &lt;SPAN&gt;Qlik Application&amp;nbsp;&amp;nbsp;Automation&lt;/SPAN&gt;? Is there such a possibility?&lt;/P&gt;</description>
      <pubDate>Tue, 04 Apr 2023 11:13:02 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2056814#M5702</guid>
      <dc:creator>mar1opl</dc:creator>
      <dc:date>2023-04-04T11:13:02Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Application Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2061350#M5705</link>
      <description>&lt;P&gt;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/177788"&gt;@mar1opl&lt;/a&gt;&amp;nbsp;I am not able to locate the invite new user block or equivalent API.&amp;nbsp; If there is then we can create another automation to loop through the list to invite, and once they joined then assign them to the correct spaces&lt;/P&gt;</description>
      <pubDate>Tue, 18 Apr 2023 06:25:43 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2061350#M5705</guid>
      <dc:creator>Edy_Tan</dc:creator>
      <dc:date>2023-04-18T06:25:43Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Application Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2081899#M5722</link>
      <description>&lt;P&gt;HI Dear&amp;nbsp;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/47366"&gt;@Edy_Tan&lt;/a&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Can you provide me the search synax used on&amp;nbsp;&lt;SPAN&gt;Search Users block&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Thu, 08 Jun 2023 22:26:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2081899#M5722</guid>
      <dc:creator>marcos_herrera</dc:creator>
      <dc:date>2023-06-08T22:26:44Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Application Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2081911#M5723</link>
      <description>&lt;P&gt;&lt;a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/235"&gt;@marcos_herrera&lt;/a&gt;&amp;nbsp;the search syntax I used is&amp;nbsp;&lt;STRONG&gt;&lt;EM&gt;email co "john.doe@mail.com".&lt;/EM&gt;&lt;/STRONG&gt;&amp;nbsp; Co means contain.&amp;nbsp; There are others examples &lt;A href="https://qlik.dev/apis/rest/users" target="_self"&gt;here.&lt;/A&gt;&amp;nbsp;For more syntax you can refer to page 17 &lt;A href="https://datatracker.ietf.org/doc/rfc7644/" target="_self"&gt;here&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 09 Jun 2023 00:17:22 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2081911#M5723</guid>
      <dc:creator>Edy_Tan</dc:creator>
      <dc:date>2023-06-09T00:17:22Z</dc:date>
    </item>
    <item>
      <title>Re: Using Qlik Application Automation to add users into spaces</title>
      <link>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2456629#M5831</link>
      <description>&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Mon, 27 May 2024 14:36:31 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Qlik-Sense-Documents/Using-Qlik-Application-Automation-to-add-users-into-spaces/tac-p/2456629#M5831</guid>
      <dc:creator>F_B</dc:creator>
      <dc:date>2024-05-27T14:36:31Z</dc:date>
    </item>
  </channel>
</rss>

