whitemx

//- Pagination mixin
//- ----------------
//- start=# to start pagination at
//- numpages=# links to serve up
//- base=base url before num
//-
//- Example:
//- pagination(1,5,4,'/disc/','?keywords=test')
//- Yields: | < | 3 | 4 | 5 | 6 | 7 | > |
//- « = /disc/2, 3 = /disc/3, 4 = #, .. 7 = /disc/7, » = /disc/8

whitemx

let
  PageRange = {1..100},
  Source = List.Transform(PageRange, each try {_, fnGetCollectionData(_)} otherwise null),
  First = List.FirstN(Source, each _ <> null),
  Table = Table.FromRows(First, {"Page", "Column1"}),
  split = Splitter.SplitTextByDelimiter(","),
  fieldnames = split(fnGetParameter("fields")), 
  Expanded = Table.ExpandTableColumn(Table, "Column1", fieldnames)
in
  Expanded

whitemx

let
  fnGetCollectionData = (start as number) as table =>
let
  endpoint = fnGetParameter("endpoint"), 
  count = fnGetParameter("count"), 
  start = start - 1, 
  apikey = fnGetParameter("apikey"), 	
  Source = Json.Document(Web.Contents(endpoint, 
    [
      Query=[ 

whitemx

//Written by Ken Puls, FCPA, FCMA, MS MVP (Excel)
//Original Source: http://www.excelguru.ca/blog/2014/11/26/building-a-parameter-table-for-power-query/

(ParameterName as text) =>
let
  ParamSource = Excel.CurrentWorkbook(){[Name="Parameters"]}[Content],
  ParamRow = Table.SelectRows(ParamSource, each ([Parameter] = ParameterName)),
  Value=if Table.IsEmpty(ParamRow)=true
    then null
    else Record.Field(ParamRow{0},"Value")

whitemx

[
  {
    "notesurl": "Notes://Mixed2/80257AC50035BEE2/9B03730C11B24C94852565E20060BED0/BC9F435105F5F9A880257C3100401F50",
    "type": "doclink",
    "documentid": "BC9F435105F5F9A880257C3100401F50",
    "apiurl": "/1.0/document/dev-londc-com-teamstudio-widgets-teamroom-nsf/Response/BC9F435105F5F9A880257C3100401F50"
  }, 
  {
    "notesurl": "Notes://Mixed2/80257AC50035BEE2/9B03730C11B24C94852565E20060BED0",
    "type": "viewlink"

whitemx

	<unp:UnpBootHeader>
		<unp:this.navitems><![CDATA[#{javascript:[
        {label: "Dashboard", hasSubMenu: false, page: "/UnpMain.xsp", icon: "fa-dashboard"},
        {label: "Lists", icon: "fa-list", children: [
			{"label": "Flat", "icon": "fa-list-alt", "page": "/FlatView.xsp"},
			{"label": "Detailed", "icon": "fa-list-alt", "page": "/DetailView.xsp"},
			{"label": "Categorized", "icon": "fa-list", "page": "/Categorized.xsp"},
			{"label": "Accordion", "icon": "fa-th-list", "page": "/Accordion.xsp"} 
		]},
        {label: "Cards", hasSubMenu: false, page: "/BaseCards.xsp", icon: "fa-book"},

whitemx

#The email address of the user running the migration (this will match the email of the super user account at LDC Via)
user.email = [email protected]
 
#Language the tool will run in. Currently only EN is supported, if you need other languages please let us know
language = EN
 
#The server the source nsf files can be found on leave this empty to use the current server (which is the setting that you would use is you were running the utility on the actual Domino server)
nsf.sourceServerName = Apps/LDCVIA
#Multiple databases can be stipulated here separated by a "," , separate directories paths with "\\"
#At least one database must be provided

whitemx

#The email address of the user running the migration (this will match the email of the super user account at LDC Via)
user.email = [email protected]

#Language the tool will run in. Currently only EN is supported, if you need other languages please let us know
language = EN

#The server the source nsf files can be found on leave this empty to use the current server (which is the setting that you would use is you were running the utility on the actual Domino server)
nsf.sourceServerName = Apps/LDCVia
#Multiple databases can be stipulated here separated by a "," , separate directories paths with "\\"
#At least one database must be provided

whitemx

function saveNewDocument() {
  var data = {};
  data.__form = "MainTopic";
  data.Body = {
    "type": "multipart",
    "content": [{
      "contentType": "text/plain; charset=UTF-8",
      "data": "<p>Some HTML content</p>"
    }]
  };

whitemx

  var root = 'https://demo.ldcvia.com';
  var apikey = '<ENTER YOUR API KEY HERE>';
  $.ajax({
    dataType: 'json',
    type: 'GET',
    url: root + '/1.0/databases',
    data: data,
    headers: {
      'apikey': apikey
    },