{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node lets you manage the data that you want to store.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":364,"id":"6cf8c351-0dfb-4483-946a-377f9e604bdf","collection":"contentId-1091666699","type":"file","height":290}}]},{"type":"paragraph","content":[{"text":"You have the following options:","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b9f9a657-1602-49f2-9616-ad9450beed00"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"4185cf1a-4a3f-4091-ab22-de8aeaaf4415"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Model","type":"text"}]},{"type":"paragraph","content":[{"text":"You can choose the schema from this drop-down.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":491,"id":"99c5d78b-80f8-40ad-87f1-fe96e02bf668","collection":"contentId-1091666699","type":"file","height":413}}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Action","type":"text"}]},{"type":"paragraph","content":[{"text":"Choose an action from the drop-down that you want to perform on the schema.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":491,"id":"1ef8456f-3447-4800-969c-3c5b01d5674f","collection":"contentId-1091666699","type":"file","height":364}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Read","type":"text"}]},{"type":"paragraph","content":[{"text":"Based on the parameters given in the payload, the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node will fetch the data.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":547,"id":"6338b80f-eb20-4293-a587-4110c6dd581f","collection":"contentId-1091666699","type":"file","height":506}}]},{"type":"paragraph","content":[{"text":"In the previous image, the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node will fetch all the data items from the Project.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"“","type":"text"},{"text":"limit","type":"text","marks":[{"type":"strong"}]},{"text":"” specifies the number of data items to be shown per page in the result object. The maximum value is 999. Always specify a limit. If you do not specify a limit and there are more than 999 results, it will return an invalid number of results.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"“","type":"text"},{"text":"page","type":"text","marks":[{"type":"strong"}]},{"text":"” is the page number to be shown in the results object. The first page starts at 1.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"“","type":"text"},{"text":"sortBy","type":"text","marks":[{"type":"strong"}]},{"text":"” is used to sort the fetched data based on the criteria.","type":"text"},{"type":"hardBreak"},{"text":"For example, ","type":"text"},{"text":"{\"sortBy\":{\"createdAt\":-1}}","type":"text","marks":[{"type":"strong"}]},{"text":" will sort the data items shown in the result array based on the created date displaying the latest created data item first.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"The following image shows the result payload.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":602,"id":"25084dfa-9222-43fc-9837-c8fb1e8de12f","collection":"contentId-1091666699","type":"file","height":309}}]},{"type":"paragraph","content":[{"text":"You can identify a data item using the ","type":"text"},{"text":"ID","type":"text","marks":[{"type":"strong"}]},{"text":" or the ","type":"text"},{"text":"Item Name","type":"text","marks":[{"type":"strong"}]},{"text":". You can use either of them to get the data item in the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":75.0},"content":[{"type":"media","attrs":{"width":602,"id":"f024c274-51a5-484b-9fab-9e39954983ed","collection":"contentId-1091666699","type":"file","height":161}}]},{"type":"paragraph","content":[{"text":"The ID is unique for a data item. You will get only one result when you use the correct ID.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":364,"id":"abb738b4-f091-41e2-8b52-8c3dfb3ba474","collection":"contentId-1091666699","type":"file","height":224}}]},{"type":"paragraph","content":[{"text":"Item Name","type":"text","marks":[{"type":"strong"}]},{"text":" is asked while creating the ","type":"text"},{"text":"Data item","type":"text","marks":[{"type":"strong"}]},{"text":" manually. Multiple data items can have the same item name. You can query the data using the item name.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":364,"id":"aee7d179-aa94-4351-80ff-b3aba3c8d4b1","collection":"contentId-1091666699","type":"file","height":230}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Example 1","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"The below example will return all the values that have the ","type":"text"},{"text":"status","type":"text","marks":[{"type":"strong"}]},{"text":" as ","type":"text"},{"text":"Inactive","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"age","type":"text","marks":[{"type":"strong"}]},{"text":" greater than ","type":"text"},{"text":"32","type":"text","marks":[{"type":"strong"}]},{"text":", and whose page number equals the dynamic value passed.","type":"text"}]},{"type":"paragraph","content":[{"text":"If there are more than 999 items we need to concatenate the results.","type":"text"}]},{"type":"paragraph","content":[{"text":"Because we are doing a loop to get all the pages of data, it is a good idea while testing to add a delay to throttle the number of query requests, in case you make a mistake and created an infinite loop. Then either changes the delay to 1 ms or remove the delay completely.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1169,"id":"032dc5b8-f8d8-4df7-a52a-912220c6c405","collection":"contentId-1091666699","type":"file","height":287}}]},{"type":"paragraph","content":[{"text":"The Dynamic Data Manager node is set to ","type":"text"},{"text":"Read","type":"text","marks":[{"type":"strong"}]},{"text":". The ","type":"text"},{"text":"AND ","type":"text","marks":[{"type":"strong"}]},{"text":"condition is set for ","type":"text"},{"text":"status ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"age","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The number of documents per page is 999 items. Which is the max limit.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":544,"id":"322e576c-197f-4050-9c72-c799315375c6","collection":"contentId-1091666699","type":"file","height":479}}]},{"type":"paragraph","content":[{"text":"In ","type":"text"},{"text":"sortBy","type":"text","marks":[{"type":"code"}]},{"text":", we used ","type":"text"},{"text":"createdAt","type":"text","marks":[{"type":"code"}]},{"text":". You can also use ","type":"text"},{"text":"modifiedAt","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"createdAt","type":"text","marks":[{"type":"code"}]},{"text":", ","type":"text"},{"text":"modifiedAt","type":"text","marks":[{"type":"code"}]},{"text":", and ","type":"text"},{"text":"_id","type":"text","marks":[{"type":"code"}]},{"text":" are always returned in the collection.","type":"text"}]},{"type":"codeBlock","content":[{"text":"{ \n\"$and\": [{ \n \"status\": \"Inactive\" \n }, \n { \n \"age\":{ \"$gte\":\"32\" } \n }],\n\"createdAt\": { \"$gt\" : \"{{msg.startDate}}\" },\n\"limit\": 999,\n\"page\": \"{{msg.pagePntr}}\",\n\"sortBy\": {\"createdAt\":-1}\n} \n","type":"text"}]},{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"init function node","type":"text","marks":[{"type":"em"}]},{"text":", set up the ","type":"text"},{"text":"pagePntr","type":"text","marks":[{"type":"code"}]},{"text":" to start at 1. A common mistake is to start at 0.","type":"text"},{"type":"hardBreak"},{"text":"Also setting up the array to store the results, in this case, ","type":"text"},{"text":"msg.userDataArray = [ ]","type":"text","marks":[{"type":"code"}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":694,"id":"6fb36272-0ae0-4701-959a-8cc0fc774563","collection":"contentId-1091666699","type":"file","height":359}}]},{"type":"codeBlock","content":[{"text":"msg.pagePntr = 1; // init page pointer to 1\nmsg.userDataArray = []; // init aray\nvar moment = global.get('moment');\nconst now = moment(); // use moment to creat time 20 days earlier than today\nconst DaysAgo = now.subtract(20, \"days\").startOf(\"day\").utc().toISOString();\nmsg.startDate = DaysAgo;\nreturn msg;\n","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"loop function node ","type":"text","marks":[{"type":"em"}]},{"text":"concatenates the results of each page until it collects all the data.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":717,"id":"fa2fd45b-894c-4afb-8ad8-aa11b15af4f4","collection":"contentId-1091666699","type":"file","height":364}}]},{"type":"codeBlock","content":[{"text":"var userData = msg.data.dynamicData.result; // Get the results from dynamic data node.\nif (userData.length > 0) { // is there any data.\n msg.userDataArray = msg.userDataArray.concat(userData); // append to the last array.\n msg.pagePntr = parseInt(msg.pagePntr) + 1; // increment the page pointer.\n // node.warn('Next page ' + msg.pagePntr);\n if(msg.data.dynamicData.paging.hasMore.hasNext === false) { // is there another page. if not exit loop\n return [null,msg] \n } else {\n return [msg,null] // get the next page of data.\n }\n} else {\n return [null,msg] // no data\n}\n","type":"text"}]},{"type":"mediaGroup","content":[{"type":"media","attrs":{"id":"74b218aa-ed02-4dae-8eff-2a19b24ee0cf","collection":"contentId-1091666699","type":"file"}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Example 2","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"This example deals with the ","type":"text"},{"text":"Read, OR condition, AND, NOT Equal.","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"You can get more query commands at ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://docs.mongodb.com/manual/tutorial/query-documents/"}},{"text":" ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":746,"id":"f7d5d8b0-133b-446d-9547-9d8eb66f9ff7","collection":"contentId-1091666699","type":"file","height":477}}]},{"type":"codeBlock","content":[{"text":"{\n\"$or\": [{\"runStatus\": \"start\"}, {\"acknowledge\": \"yes\"}], \n \"runStatus\": { \"$ne\": \"Complete\" },\n\"limit\": 900,\n\"page\": 1,\n\"sortBy\": {\"createdAt\":-1}\n} \n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Create","type":"text"}]},{"type":"paragraph","content":[{"text":"Lets you create a new data item. If you don’t specify a project ID in the payload, the data is created as Global data.","type":"text"}]},{"type":"paragraph","content":[{"text":"As shown in the following image, the payload may contain hard-coded values or mustache tags. Data in the mustache tag is converted to a string while saving the data.","type":"text"}]},{"type":"panel","attrs":{"panelType":"success"},"content":[{"type":"paragraph","content":[{"text":"To avoid encoded or Unicode characters getting saved, place an ampersand (&) in the mustache tag.","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":364,"id":"6071aab3-fd67-4e8e-b6cf-737aec8735f9","collection":"contentId-1091666699","type":"file","height":268}}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Creating multiple data items","type":"text"}]},{"type":"paragraph","content":[{"text":"You can create multiple data items at the same time in two ways.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Place multiple objects in an array","type":"text","marks":[{"type":"strong"}]},{"text":". In the following image, an array with two data items is given in the payload of the Dynamic Data Manager node.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":491,"id":"6316ec99-d2ce-411a-a28f-9b4a5f0d7dbb","collection":"contentId-1091666699","type":"file","height":501}}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create an array in the function node","type":"text","marks":[{"type":"strong"}]},{"text":" placed before the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node. The following code lets you create a sample array and store it in ","type":"text"},{"text":"msg.payload.data","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]}]}]},{"type":"codeBlock","content":[{"text":"var _ = global.get('lodash');\nvar sample = [\n {\n SampleText : \"Google\",\n SampleURL : \"https://www.google.com/\"\n },\n {\n SampleText : \"Amazon\",\n SampleURL : 'https://www.amazon.com/'\n }\n ];\n_.set(msg,'payload.data',sample);\n","type":"text"}]},{"type":"paragraph","content":[{"text":"When using this method to create multiple data items, the payload in the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node should be left empty.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Update","type":"text"}]},{"type":"paragraph","content":[{"text":"If the field is available in the schema, the content of that field will be updated with the content given in the payload. The ","type":"text"},{"text":"_id","type":"text","marks":[{"type":"em"}]},{"text":" is used to identify the data item (required). The field that you want to update must be inside the data object. For example, in the following image, ","type":"text"},{"text":"hospitalCounty","type":"text","marks":[{"type":"em"}]},{"text":" is a field available in the schema that will be updated with the data “","type":"text"},{"text":"county","type":"text","marks":[{"type":"em"}]},{"text":"”.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":446,"id":"112e67c2-35d2-453c-8e4a-f225fe750260","collection":"contentId-1091666699","type":"file","height":273}}]},{"type":"paragraph","content":[{"text":"Example 2","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"In this example user, each record has a unique id called a token, only one result will be returned and we are going to update the runStatus to Complete","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1104,"id":"35c90eca-56d6-4965-b23a-107debc7d138","collection":"contentId-1091666699","type":"file","height":104}}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":504,"id":"e8968b83-1a81-46cd-86d4-8454d20d2271","collection":"contentId-1091666699","type":"file","height":424}}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":956,"id":"5949c110-21b0-4354-b3f0-c1fa0343c59a","collection":"contentId-1091666699","type":"file","height":386}}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":572,"id":"dffc271e-8957-49f2-b57f-1e01f3e92d7f","collection":"contentId-1091666699","type":"file","height":440}}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Upsert","type":"text"}]},{"type":"paragraph","content":[{"text":"If multiple results are found for a query, the oldest data item gets updated.","type":"text"}]},{"type":"paragraph","content":[{"text":"Queries fields are available","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"If the queried fields are available, the schema fields are updated with the content given in the payload. In the following example, queried fields are available, but one of the payload properties is not available in the schema. ","type":"text"},{"text":"NewField","type":"text","marks":[{"type":"strong"}]},{"text":" is not available in the schema. Except for ","type":"text"},{"text":"NewField","type":"text","marks":[{"type":"strong"}]},{"text":", all the other fields will be updated based on the payload.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":364,"id":"f294b535-b4ff-4e2c-9b35-226f35ffc71a","collection":"contentId-1091666699","type":"file","height":416}}]},{"type":"paragraph","content":[{"text":"Alternatively, ","type":"text","marks":[{"type":"strong"}]},{"text":"you can ","type":"text"},{"text":"create an array in the function node","type":"text","marks":[{"type":"strong"}]},{"text":" placed before the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node to send the data to ","type":"text"},{"text":"msg.payload.data","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"codeBlock","content":[{"text":"var data = \n{\n \"ids\": [\n \"221778457701379939\"\n ],\n \"221778457701379939\": {\n \"q\": \"

$\\\"\\\"$

\\n\\n

Hey there! I’m Wanda from New York.

\\n

If you’re pregnant, have a baby, or have a little one up to 5 years old, WIC is here to support you!

\\n

Citizenship and immigration status doesn’t matter, and, of course, this discussion is private.

\\n

I’m here to make your life a little easier. Click Start if you’re cool with the Terms and Privacy Policy!

\\n\",\n \"question\": \"

Hey there! I’m Wanda from New York.
If you’re pregnant, have a baby, or have a little one up to 5 years old, WIC is here to support you!
Citizenship and immigration status doesn’t matter, and, of course, this discussion is private.
I’m here to make your life a little easier. Click Start if you’re cool with the Terms and Privacy Policy!
\",\n \"startTime\": \"2020-07-03T09:21:18.531Z\",\n \"endTime\": \"2020-07-03T09:21:34.216Z\",\n \"answer\": \"Start\"\n }\n}\nmsg.payload.data = \n{\n \"jsonfield_schemakey\": data\n};\nreturn msg;\n","type":"text"}]},{"type":"paragraph","content":[{"text":"When using this method to create multiple data items, the payload in the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node should be left empty.","type":"text"}]},{"type":"paragraph","content":[{"text":"Queried fields are not available","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"If the queried fields are not available, it creates a data item and update the available fields in the schema based on the payload. For example, the following image shows the ","type":"text"},{"text":"Newquery","type":"text","marks":[{"type":"strong"}]},{"text":" is not available as a field in the schema. Therefore, a new data item with a new id will be created with the payload.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":55.0},"content":[{"type":"media","attrs":{"width":364,"id":"af40255a-d0cf-49d6-a15f-d268fa189c79","collection":"contentId-1091666699","type":"file","height":394}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Delete","type":"text"}]},{"type":"paragraph","content":[{"text":"You can Delete the data using a query. If the query matches multiple Data items, each of them is deleted.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":65.0},"content":[{"type":"media","attrs":{"width":364,"id":"754974ba-82c6-44d7-aa04-d803857d3707","collection":"contentId-1091666699","type":"file","height":221}}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Payload","type":"text"}]},{"type":"paragraph","content":[{"text":"A ","type":"text"},{"text":"Function","type":"text","marks":[{"type":"strong"}]},{"text":" node should be placed prior to the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node to verify the mandatory fields of the schema (model). These schema fields will be saved/queried based on the details given in this payload field of the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node.","type":"text"}]},{"type":"paragraph","content":[{"text":"The output for the ","type":"text"},{"text":"Dynamic Data Manager","type":"text","marks":[{"type":"strong"}]},{"text":" node will be in the ","type":"text"},{"text":"msg.data","type":"text","marks":[{"type":"strong"}]},{"text":" object.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Video Content","type":"text"}]},{"type":"paragraph","content":[{"text":"https://cdn.orbita.cloud/assets/orbita/experiencedesigner/dynamicdatamanager.mp4","type":"text","marks":[{"type":"link","attrs":{"href":"https://cdn.orbita.cloud/assets/orbita/experiencedesigner/dynamicdatamanager.mp4"}}]},{"text":" ","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Useful Links","type":"text"}]},{"type":"paragraph","content":[{"text":"http://orbita.ai","type":"text","marks":[{"type":"link","attrs":{"href":"http://orbita.ai/"}}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Related Content","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"pagetree","parameters":{"macroParams":{"root":{"value":"3.2 Experience Designer Technical Training"}},"macroMetadata":{"macroId":{"value":"ba05ea1e-9012-48ab-ac54-f7c8f8390c68"},"schemaVersion":{"value":"1"},"title":"Page Tree"}},"localId":"3e6ed978-0e73-460a-8e08-aa280f872d3c"}}]}],"version":1}

Browser not supported