Client Delivery
Choose compatible client pilot-test sessions — Reviewer CSV file
Select nonoverlapping client pilot-test sessions from preapproved offered windows using supplied acceptance priorities. Prepare a Reviewer CSV file.
Experimental native example · local preview · revision 1
WORKFLOW PREVIEW
See how it works
Use + and − to zoom, F to fit. Press Enter on a node to inspect it.
Private preview. These tested drafts are available for inspection. Adding them to a Vora workspace is still being tested.
What you need
- Authorized supplied job facts matching the original closed input contract.
- Explicit review metadata and target destination fields; no implicit team, channel, list or project selection.
Follow the workflow step by step
Supplied agency job and review metadata
Receive the explicitly supplied manual input packet.
Choose compatible client pilot-test sessions
Select nonoverlapping client pilot-test sessions from preapproved offered windows using supplied acceptance priorities.
- default: Reviewer CSV file
Reviewer CSV file
Select nonoverlapping client pilot-test sessions from preapproved offered windows using supplied acceptance priorities.
Setup and review
- Download the workflow JSON and inspect its jobInput and deliveryMetadata contracts.
- Supply the original agency job input plus explicit review metadata and destination.
- Run in an isolated test and inspect the complete jobResult, target status, holds and escape report before taking an external action.
Inspect every node
Expand a node to inspect its complete settings. Review the runtime and adoption evidence before installing it.
Supplied agency job and review metadata · wfManualTrigger
{
"label": "Supplied agency job and review metadata"
}Choose compatible client pilot-test sessions · code
{
"label": "Choose compatible client pilot-test sessions",
"code": "return (function(context){\n\nfunction fail(reason){throw new Error('input: '+reason);}\nfunction check(schema,value,where){\n if(value===null){if(schema.type==='null'||Array.isArray(schema.type)&&schema.type.includes('null'))return;fail(where+' wrong_type');}\n const type=Array.isArray(schema.type)?schema.type[0]:schema.type;\n if(type==='object'){\n if(!value||typeof value!=='object'||Array.isArray(value))fail(where+' wrong_type');\n for(const name of Object.keys(value))if(!Object.hasOwn(schema.properties,name))fail(where+' unknown_field');\n for(const name of schema.required)if(!Object.hasOwn(value,name))fail(where+' missing_field');\n for(const [name,shape]of Object.entries(schema.properties))check(shape,value[name],where+'.'+name);\n }else if(type==='array'){\n if(!Array.isArray(value)||value.length>schema.maxItems)fail(where+' array_bound');\n for(const item of value)check(schema.items,item,where+'[]');\n }else if(type==='string'){if(typeof value!=='string'||value.length>schema.maxLength)fail(where+' string_bound');}\n else if(type==='integer'){if(!Number.isSafeInteger(value)||value<schema.minimum||value>schema.maximum)fail(where+' integer_bound');}\n else if(type==='boolean'){if(typeof value!=='boolean')fail(where+' wrong_type');}\n else fail(where+' unsupported_type');\n}\nfunction id(value){if(typeof value!=='string'||!value||value.trim()!==value)fail('noncanonical_identity');return value;}\nfunction unique(values,reason){if(new Set(values).size!==values.length)fail(reason);}\nfunction safeAdd(a,b){if(a>Number.MAX_SAFE_INTEGER-b)fail('unsafe_sum');return a+b;}\nfunction day(value){if(!/^\\d{4}-\\d{2}-\\d{2}$/.test(value))fail('invalid_calendar_day');const ms=Date.parse(value+'T00:00:00Z');if(!Number.isFinite(ms)||new Date(ms).toISOString().slice(0,10)!==value)fail('invalid_calendar_day');return ms;}\nfunction refKey(ref){id(ref.assetId);if(ref.version<1)fail('positive_version_required');return JSON.stringify([ref.assetId,ref.version]);}\nfunction refValue(key){const pair=JSON.parse(key);return {assetId:pair[0],version:pair[1]};}\nfunction sortedRefs(keys){return [...keys].sort().map(refValue);}\n\nfunction lexIds(a,b){for(let i=0;i<Math.min(a.length,b.length);i++){if(a[i]<b[i])return -1;if(a[i]>b[i])return 1;}return a.length-b.length;}\nfunction maxSubset(rows,idField,feasible){let best=-1,ids=[],ties=0;for(let mask=0;mask<2**rows.length;mask++){const chosen=rows.filter((_,i)=>mask&(1<<i));if(!feasible(chosen))continue;const value=chosen.reduce((n,r)=>n+r.valuePoints,0),current=chosen.map(r=>r[idField]).sort();if(value>best){best=value;ids=current;ties=1;}else if(value===best){ties++;if(lexIds(current,ids)<0)ids=current;}}return {ids,value:best,ties};}\nfunction rat(n,d){if(d===0n)fail('zero_denominator');if(d<0n){n=-n;d=-d;}let a=n<0n?-n:n,b=d;while(b){const next=a%b;a=b;b=next;}return [n/a,d/a];}\nfunction ratAdd(a,b){return rat(a[0]*b[1]+b[0]*a[1],a[1]*b[1]);}\nfunction ratSub(a,b){return rat(a[0]*b[1]-b[0]*a[1],a[1]*b[1]);}\nfunction ratMul(a,b){return rat(a[0]*b[0],a[1]*b[1]);}\nfunction ratText(a){return a[0].toString()+'/'+a[1].toString();}\n\n\ncheck({\"type\":\"object\",\"properties\":{\"scopeId\":{\"type\":\"string\",\"maxLength\":128},\"selectionComplete\":{\"type\":[\"boolean\",\"null\"]},\"sessions\":{\"type\":\"array\",\"items\":{\"type\":\"object\",\"properties\":{\"sessionId\":{\"type\":\"string\",\"maxLength\":128},\"startMinute\":{\"type\":\"integer\",\"minimum\":0,\"maximum\":1440},\"endMinute\":{\"type\":\"integer\",\"minimum\":0,\"maximum\":1440},\"valuePoints\":{\"type\":[\"integer\",\"null\"],\"minimum\":0,\"maximum\":1000000}},\"required\":[\"sessionId\",\"startMinute\",\"endMinute\",\"valuePoints\"],\"additionalProperties\":false},\"maxItems\":12}},\"required\":[\"scopeId\",\"selectionComplete\",\"sessions\"],\"additionalProperties\":false},context.input,\"input\");\nconst result=(function sessions(x){\n id(x.scopeId);unique(x.sessions.map(s=>id(s.sessionId)),'duplicate_session_id');for(const s of x.sessions)if(s.endMinute<=s.startMinute)fail('invalid_interval');\n const unknown=x.sessions.filter(s=>s.valuePoints===null).map(s=>s.sessionId).sort();\n if(x.selectionComplete!==true||unknown.length)return {status:'unknown',selectedIds:[],totalValuePoints:null,optimalTieCount:null,unknownSessionIds:unknown};\n const choice=maxSubset(x.sessions,'sessionId',rows=>rows.every((a,i)=>rows.slice(i+1).every(b=>a.endMinute<=b.startMinute||b.endMinute<=a.startMinute)));\n return {status:'optimal_within_supplied_sessions',selectedIds:choice.ids,totalValuePoints:choice.value,optimalTieCount:choice.ties,unknownSessionIds:[]};\n})(context.input);\ncheck({\"type\":\"object\",\"properties\":{\"status\":{\"type\":\"string\",\"maxLength\":128},\"selectedIds\":{\"type\":\"array\",\"items\":{\"type\":\"string\",\"maxLength\":128},\"maxItems\":100},\"totalValuePoints\":{\"type\":[\"integer\",\"null\"],\"minimum\":0,\"maximum\":12000000},\"optimalTieCount\":{\"type\":[\"integer\",\"null\"],\"minimum\":0,\"maximum\":4096},\"unknownSessionIds\":{\"type\":\"array\",\"items\":{\"type\":\"string\",\"maxLength\":128},\"maxItems\":100}},\"required\":[\"status\",\"selectedIds\",\"totalValuePoints\",\"optimalTieCount\",\"unknownSessionIds\"],\"additionalProperties\":false},result,\"output\");\nreturn result;\n})({input:context.input.jobInput});\n",
"outputVar": "jobResult",
"timeout": 3000,
"memoryLimit": 64
}Reviewer CSV file · code
{
"label": "Reviewer CSV file",
"code": "const jobResult=context.jobResult;\nconst delivery=(function(context){\nreturn ((function(originalResult,metadata,destination){\nfunction stableResult(value,depth=0){\n if(depth>64)throw new Error('Result nesting exceeds 64');\n if(value===null||typeof value==='string'||typeof value==='boolean')return JSON.stringify(value);\n if(typeof value==='number'&&Number.isFinite(value))return JSON.stringify(value);\n if(Array.isArray(value)){\n if(Object.keys(value).length!==value.length||Array.from({length:value.length},(_,i)=>i).some(i=>!Object.hasOwn(value,i)))throw new Error('Result contains sparse data');\n return '['+value.map(item=>stableResult(item,depth+1)).join(',')+']';\n }\n if(value&&typeof value==='object')return '{'+Object.keys(value).sort().map(key=>JSON.stringify(key)+':'+stableResult(value[key],depth+1)).join(',')+'}';\n throw new Error('Result is not JSON data');\n}\nfunction utf8Length(text){\n let bytes=0;\n for(let i=0;i<text.length;i++){\n const code=text.charCodeAt(i);\n if(code<128)bytes++;else if(code<2048)bytes+=2;\n else if(code>=55296&&code<=56319&&i+1<text.length&&text.charCodeAt(i+1)>=56320&&text.charCodeAt(i+1)<=57343){bytes+=4;i++;}\n else bytes+=3;\n }\n return bytes;\n}\nfunction chunkText(text,maximum){\n const chunks=[];\n for(let start=0;start<text.length;){let end=Math.min(start+maximum,text.length);const last=text.charCodeAt(end-1),next=text.charCodeAt(end);if(end<text.length&&last>=55296&&last<=56319&&next>=56320&&next<=57343)end--;chunks.push(text.slice(start,end));start=end;}\n return chunks;\n}\nfunction deliveryState(rendererId,originalResult,metadata,destination,destinationKeys){\n const output={rendererId,status:'HELD',originalResult,drafts:[],holds:[],escapeReport:[]};\n const hold=(code,message)=>{output.holds.push({code,message});return {output,json:''};};\n const object=value=>value&&typeof value==='object'&&!Array.isArray(value);\n const exact=(value,keys)=>object(value)&&Object.keys(value).length===keys.length&&keys.every(key=>Object.hasOwn(value,key));\n const keys=['workflowId','canonicalIntentId','title','reviewUrl'],maxima=[128,200,200,1000];\n if(!exact(metadata,keys)||keys.some((key,i)=>typeof metadata[key]!=='string'||!metadata[key].length||metadata[key].length>maxima[i]||/[\\u0000-\\u001f\\u007f]/.test(metadata[key]))||!/^https?:\\/\\/[^\\s<>\"']+$/.test(metadata.reviewUrl))return hold('INVALID_METADATA','Metadata must provide bounded workflowId, canonicalIntentId, title and an HTTP(S) reviewUrl.');\n if(!exact(destination,destinationKeys)||destinationKeys.some(key=>typeof destination[key]!=='string'||!destination[key].length||destination[key].length>200||destination[key]!==destination[key].trim()||/[\\u0000-\\u001f\\u007f]/.test(destination[key])))return hold('INVALID_DESTINATION','Destination fields must be exactly: '+destinationKeys.join(', ')+'.');\n let json;\n try{if(!object(originalResult))throw new Error('Primary result must be a JSON object');json=stableResult(originalResult);}catch(error){return hold('INVALID_RESULT',error.message);}\n if(json.length>32768||utf8Length(json)>65536)return hold('RESULT_BOUND_EXCEEDED','Original result exceeds this renderer profile; full original result is retained.');\n return {output,json};\n}\nfunction escapeHtml(text){return text.replace(/&/g,'&').replace(/</g,'<').replace(/>/g,'>').replace(/\"/g,'"').replace(/'/g,''');}\nfunction escapeMarkdown(text){return text.replace(/&/g,'&').replace(/[\\\\`*{}\\[\\]()#+\\-.!_|>~<]/g,'\\\\$&');}\nfunction markdownReviewText(metadata,json){\n const runs=json.match(/`+/g)||[],fence='`'.repeat(Math.max(3,...runs.map(run=>run.length+1)));\n return '# '+escapeMarkdown(metadata.title)+'\\n\\nWorkflow: '+escapeMarkdown(metadata.workflowId)+'\\nCanonical job: '+escapeMarkdown(metadata.canonicalIntentId)+'\\nReview: <'+metadata.reviewUrl.replace(/&/g,'&')+'>\\n\\n'+fence+'json\\n'+json+'\\n'+fence+'\\n';\n}\nfunction plainReviewText(metadata,json){return metadata.title+'\\nWorkflow: '+metadata.workflowId+'\\nCanonical job: '+metadata.canonicalIntentId+'\\nReview: '+metadata.reviewUrl+'\\n\\n'+json;}\nfunction finishDraft(state,draft,texts=[],textMaximum=32768,byteMaximum=131072){\n if(texts.some(text=>text.length>textMaximum)||utf8Length(JSON.stringify(draft))>byteMaximum){state.output.holds.push({code:'TARGET_BOUND_EXCEEDED',message:'Draft exceeds the target or Vora profile bound; no draft is emitted and the full original result is retained.'});return state.output;}\n state.output.status='PREPARED';state.output.drafts=[draft];return state.output;\n}\nreturn (function reviewerCsv(originalResult,metadata,destination){\n const state=deliveryState('reviewer-csv',originalResult,metadata,destination,[]);if(state.output.holds.length)return state.output;\n const fields=['workflowId','canonicalIntentId','title','reviewUrl','resultJson'];\n const values=[metadata.workflowId,metadata.canonicalIntentId,metadata.title,metadata.reviewUrl,state.json].map((value,index)=>{\n if(/^\\s*[=+\\-@]/.test(value)){const escapedValue=\"'\"+value;state.output.escapeReport.push({field:fields[index],method:'prefix-apostrophe-v1',originalValue:value,escapedValue});return escapedValue;}return value;\n });\n const quote=value=>'\"'+value.replace(/\"/g,'\"\"')+'\"';\n const text=fields.map(quote).join(',')+'\\r\\n'+values.map(quote).join(',')+'\\r\\n';\n return finishDraft(state,{mediaType:'text/csv; charset=utf-8',text},[text]);\n})(originalResult,metadata,destination);\n}))(context.input.jobResult,context.input.deliveryMetadata.metadata,context.input.deliveryMetadata.destination);\n\n})({input:{jobResult,deliveryMetadata:context.input.deliveryMetadata}});\nreturn {jobResult,delivery};\n",
"outputVar": "result",
"timeout": 3000,
"memoryLimit": 64
}Input and output contracts
Input
{
"type": "object",
"properties": {
"jobInput": {
"type": "object",
"properties": {
"scopeId": {
"type": "string",
"maxLength": 128
},
"selectionComplete": {
"type": [
"boolean",
"null"
]
},
"sessions": {
"type": "array",
"items": {
"type": "object",
"properties": {
"sessionId": {
"type": "string",
"maxLength": 128
},
"startMinute": {
"type": "integer",
"minimum": 0,
"maximum": 1440
},
"endMinute": {
"type": "integer",
"minimum": 0,
"maximum": 1440
},
"valuePoints": {
"type": [
"integer",
"null"
],
"minimum": 0,
"maximum": 1000000
}
},
"required": [
"sessionId",
"startMinute",
"endMinute",
"valuePoints"
],
"additionalProperties": false
},
"maxItems": 12
}
},
"required": [
"scopeId",
"selectionComplete",
"sessions"
],
"additionalProperties": false
},
"deliveryMetadata": {
"type": "object",
"properties": {
"metadata": {
"type": "object",
"properties": {
"workflowId": {
"type": "string",
"maxLength": 128
},
"canonicalIntentId": {
"type": "string",
"maxLength": 200
},
"title": {
"type": "string",
"maxLength": 200
},
"reviewUrl": {
"type": "string",
"maxLength": 1000
}
},
"required": [
"workflowId",
"canonicalIntentId",
"title",
"reviewUrl"
],
"additionalProperties": false
},
"destination": {
"type": "object",
"properties": {},
"required": [],
"additionalProperties": false
}
},
"required": [
"metadata",
"destination"
],
"additionalProperties": false
}
},
"required": [
"jobInput",
"deliveryMetadata"
],
"additionalProperties": false
}Output
{
"type": "object",
"properties": {
"jobResult": {
"type": "object",
"properties": {
"status": {
"type": "string",
"maxLength": 128
},
"selectedIds": {
"type": "array",
"items": {
"type": "string",
"maxLength": 128
},
"maxItems": 100
},
"totalValuePoints": {
"type": [
"integer",
"null"
],
"minimum": 0,
"maximum": 12000000
},
"optimalTieCount": {
"type": [
"integer",
"null"
],
"minimum": 0,
"maximum": 4096
},
"unknownSessionIds": {
"type": "array",
"items": {
"type": "string",
"maxLength": 128
},
"maxItems": 100
}
},
"required": [
"status",
"selectedIds",
"totalValuePoints",
"optimalTieCount",
"unknownSessionIds"
],
"additionalProperties": false
},
"delivery": {
"type": "object",
"properties": {
"rendererId": {
"type": "string",
"maxLength": 128,
"enum": [
"reviewer-csv"
]
},
"status": {
"type": "string",
"maxLength": 16,
"enum": [
"PREPARED",
"HELD"
]
},
"originalResult": {
"type": "object",
"properties": {
"status": {
"type": "string",
"maxLength": 128
},
"selectedIds": {
"type": "array",
"items": {
"type": "string",
"maxLength": 128
},
"maxItems": 100
},
"totalValuePoints": {
"type": [
"integer",
"null"
],
"minimum": 0,
"maximum": 12000000
},
"optimalTieCount": {
"type": [
"integer",
"null"
],
"minimum": 0,
"maximum": 4096
},
"unknownSessionIds": {
"type": "array",
"items": {
"type": "string",
"maxLength": 128
},
"maxItems": 100
}
},
"required": [
"status",
"selectedIds",
"totalValuePoints",
"optimalTieCount",
"unknownSessionIds"
],
"additionalProperties": false
},
"drafts": {
"type": "array",
"items": {
"type": "object",
"properties": {
"mediaType": {
"type": "string",
"maxLength": 80,
"enum": [
"text/csv; charset=utf-8"
]
},
"text": {
"type": "string",
"maxLength": 32768
}
},
"required": [
"mediaType",
"text"
],
"additionalProperties": false
},
"maxItems": 1,
"minItems": 0
},
"holds": {
"type": "array",
"items": {
"type": "object",
"properties": {
"code": {
"type": "string",
"maxLength": 128
},
"message": {
"type": "string",
"maxLength": 2000
}
},
"required": [
"code",
"message"
],
"additionalProperties": false
},
"maxItems": 10,
"minItems": 0
},
"escapeReport": {
"type": "array",
"items": {
"type": "object",
"properties": {
"field": {
"type": "string",
"maxLength": 256
},
"method": {
"type": "string",
"maxLength": 80
},
"originalValue": {
"type": "string",
"maxLength": 32768
},
"escapedValue": {
"type": "string",
"maxLength": 32768
}
},
"required": [
"field",
"method",
"originalValue",
"escapedValue"
],
"additionalProperties": false
},
"maxItems": 1000,
"minItems": 0
}
},
"required": [
"rendererId",
"status",
"originalResult",
"drafts",
"holds",
"escapeReport"
],
"additionalProperties": false
}
},
"required": [
"jobResult",
"delivery"
],
"additionalProperties": false
}Related implementations
Compare implementations for this job · Primary business workflow
All five fields are quoted, embedded double quotes are doubled, records end in CRLF. Formula-like cells beginning with optional whitespace then = + - @ receive one leading apostrophe. escapeReport records field, originalValue and escapedValue; remove that one recorded prefix to recover the exact original. The complete stable result JSON occupies resultJson; no spreadsheet import or formula execution is performed. Original result, including original reasons/holds, is preserved without mutation. Missing/extra destination fields or invalid metadata hold the draft. No truncation: overflow returns HELD with an empty drafts array and full original result.
Supplied input: vora-agency-session-window-value-selection · 1. Draft/result: reviewer-csv · RFC 4180 / Vora reversible formula-escape profile v1.
Mapping and loss rules
- All five fields are quoted, embedded double quotes are doubled, records end in CRLF.
- Formula-like cells beginning with optional whitespace then = + - @ receive one leading apostrophe. escapeReport records field, originalValue and escapedValue; remove that one recorded prefix to recover the exact original.
- The complete stable result JSON occupies resultJson; no spreadsheet import or formula execution is performed.
- Original result, including original reasons/holds, is preserved without mutation.
- Missing/extra destination fields or invalid metadata hold the draft.
- No truncation: overflow returns HELD with an empty drafts array and full original result.
This binding consumes supplied data. It does not establish an authenticated connector or a provider write.
Example input and result
These examples use synthetic data.
Input
{
"jobInput": {
"scopeId": "client-A",
"selectionComplete": true,
"sessions": [
{
"sessionId": "a",
"startMinute": 0,
"endMinute": 20,
"valuePoints": 2
},
{
"sessionId": "b",
"startMinute": 20,
"endMinute": 40,
"valuePoints": 3
},
{
"sessionId": "c",
"startMinute": 0,
"endMinute": 40,
"valuePoints": 4
}
]
},
"deliveryMetadata": {
"metadata": {
"workflowId": "agency-session-window-value-selection",
"canonicalIntentId": "planning.select-compatible-production-sessions",
"title": "Choose compatible client pilot-test sessions",
"reviewUrl": "https://example.test/workflows/session-window-value-selection/"
},
"destination": {}
}
}Expected result
{
"jobResult": {
"status": "optimal_within_supplied_sessions",
"selectedIds": [
"a",
"b"
],
"totalValuePoints": 5,
"optimalTieCount": 1,
"unknownSessionIds": []
},
"delivery": {
"rendererId": "reviewer-csv",
"status": "PREPARED",
"originalResult": {
"status": "optimal_within_supplied_sessions",
"selectedIds": [
"a",
"b"
],
"totalValuePoints": 5,
"optimalTieCount": 1,
"unknownSessionIds": []
},
"drafts": [
{
"mediaType": "text/csv; charset=utf-8",
"text": "\"workflowId\",\"canonicalIntentId\",\"title\",\"reviewUrl\",\"resultJson\"\r\n\"agency-session-window-value-selection\",\"planning.select-compatible-production-sessions\",\"Choose compatible client pilot-test sessions\",\"https://example.test/workflows/session-window-value-selection/\",\"{\"\"optimalTieCount\"\":1,\"\"selectedIds\"\":[\"\"a\"\",\"\"b\"\"],\"\"status\"\":\"\"optimal_within_supplied_sessions\"\",\"\"totalValuePoints\"\":5,\"\"unknownSessionIds\"\":[]}\"\r\n"
}
],
"holds": [],
"escapeReport": []
}
}Success means: Select nonoverlapping client pilot-test sessions from preapproved offered windows using supplied acceptance priorities.
When something goes wrong
- Review original business holds and target holds separately. Correct the relevant supplied input and rerun without discarding the original job result.
Limits and costs
- This prepares a target-specific review draft from the original agency decision. The complete original job result and business holds remain visible. A held target produces no draft. No provider request, send, import, issue creation or publication occurs.
- No paid model calls or metered third-party operations are declared in this pure graph. Vora plan availability, compute and quotas still apply; pricing has not been verified by this batch.