Ctrl K
Edits history of script submission #19819 for ' Update a rate table (sage_intacct)'

bun
Approved version
//native
type SageIntacct = {
	token: string
}
/**
 * Update a rate table
 * Updates an existing rate table by setting field values. Any fields not provided remain unchanged.
 */
export async function main(
	auth: SageIntacct,
	key: string,
	body: {
		key?: string
		id?: string
		name?: string
		description?: string
		location?: { key?: string; id?: string; name?: string; href?: string }
		audit?: {
			createdDateTime?: string
			modifiedDateTime?: string
			createdBy?: string
			modifiedBy?: string
		}
		status?: 'active' | 'inactive'
		entity?: { key?: string; id?: string; name?: string; href?: string }
		timesheetLines?: {
			key?: string
			id?: string
			rateTable?: { key?: string; id?: string; name?: string; href?: string }
			href?: string
			lineNumber?: number
			description?: string
			startDate?: string
			markupPercent?: string
			laborRate?: string
			accumulationType?: { key?: string; id?: string; href?: string }
			standardCostType?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			standardTask?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			employeePosition?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			laborClass?: { key?: string; id?: string; name?: string; href?: string }
			laborShift?: { key?: string; id?: string; name?: string; href?: string }
			laborUnion?: { key?: string; id?: string; name?: string; href?: string }
			timeType?: { key?: string; id?: string; name?: string; href?: string }
			dimensions?: {
				location?: { key?: string; id?: string; name?: string; href?: string }
				department?: {
					key?: string
					id?: string
					name?: string
					href?: string
				}
				employee?: { key?: string; id?: string; name?: string; href?: string }
				project?: { key?: string; id?: string; name?: string; href?: string }
				customer?: { key?: string; id?: string; name?: string; href?: string }
				vendor?: { key?: string; id?: string; name?: string; href?: string }
				item?: { key?: string; id?: string; name?: string; href?: string }
				warehouse?: { key?: string; id?: string; name?: string; href?: string }
				class?: { key?: string; id?: string; name?: string; href?: string }
				task?: { id?: string; key?: string; name?: string; href?: string }
				costType?: { id?: string; key?: string; name?: string; href?: string }
				asset?: { id?: string; key?: string; name?: string; href?: string }
				contract?: { id?: string; key?: string; name?: string; href?: string }
				affiliateEntity?: {
					key?: string
					id?: string
					href?: string
					name?: string
				}
			}
			audit?: {
				createdDateTime?: string
				modifiedDateTime?: string
				createdBy?: string
				modifiedBy?: string
			}
		}[]
		purchasingLines?: {
			key?: string
			id?: string
			rateTable?: { key?: string; id?: string; name?: string; href?: string }
			href?: string
			lineNumber?: number
			description?: string
			startDate?: string
			markupPercent?: string
			unitPrice?: string
			accumulationType?: { key?: string; id?: string; href?: string }
			standardCostType?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			standardTask?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			dimensions?: {
				location?: { key?: string; id?: string; name?: string; href?: string }
				department?: {
					key?: string
					id?: string
					name?: string
					href?: string
				}
				employee?: { key?: string; id?: string; name?: string; href?: string }
				project?: { key?: string; id?: string; name?: string; href?: string }
				customer?: { key?: string; id?: string; name?: string; href?: string }
				vendor?: { key?: string; id?: string; name?: string; href?: string }
				item?: { key?: string; id?: string; name?: string; href?: string }
				warehouse?: { key?: string; id?: string; name?: string; href?: string }
				class?: { key?: string; id?: string; name?: string; href?: string }
				task?: { id?: string; key?: string; name?: string; href?: string }
				costType?: { id?: string; key?: string; name?: string; href?: string }
				asset?: { id?: string; key?: string; name?: string; href?: string }
				contract?: { id?: string; key?: string; name?: string; href?: string }
				affiliateEntity?: {
					key?: string
					id?: string
					href?: string
					name?: string
				}
			}
			audit?: {
				createdDateTime?: string
				modifiedDateTime?: string
				createdBy?: string
				modifiedBy?: string
			}
		}[]
		accountsPayableLines?: {
			key?: string
			id?: string
			rateTable?: { key?: string; id?: string; name?: string; href?: string }
			href?: string
			lineNumber?: number
			description?: string
			startDate?: string
			markupPercent?: string
			accumulationType?: { key?: string; id?: string; href?: string }
			standardCostType?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			standardTask?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			dimensions?: {
				location?: { key?: string; id?: string; name?: string; href?: string }
				department?: {
					key?: string
					id?: string
					name?: string
					href?: string
				}
				employee?: { key?: string; id?: string; name?: string; href?: string }
				project?: { key?: string; id?: string; name?: string; href?: string }
				customer?: { key?: string; id?: string; name?: string; href?: string }
				vendor?: { key?: string; id?: string; name?: string; href?: string }
				item?: { key?: string; id?: string; name?: string; href?: string }
				warehouse?: { key?: string; id?: string; name?: string; href?: string }
				class?: { key?: string; id?: string; name?: string; href?: string }
				task?: { id?: string; key?: string; name?: string; href?: string }
				costType?: { id?: string; key?: string; name?: string; href?: string }
				asset?: { id?: string; key?: string; name?: string; href?: string }
				contract?: { id?: string; key?: string; name?: string; href?: string }
				affiliateEntity?: {
					key?: string
					id?: string
					href?: string
					name?: string
				}
			}
			audit?: {
				createdDateTime?: string
				modifiedDateTime?: string
				createdBy?: string
				modifiedBy?: string
			}
		}[]
		journalLines?: {
			key?: string
			id?: string
			rateTable?: { key?: string; id?: string; name?: string; href?: string }
			href?: string
			lineNumber?: number
			description?: string
			startDate?: string
			markupPercent?: string
			accumulationType?: { key?: string; id?: string; href?: string }
			standardCostType?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			standardTask?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			dimensions?: {
				location?: { key?: string; id?: string; name?: string; href?: string }
				department?: {
					key?: string
					id?: string
					name?: string
					href?: string
				}
				employee?: { key?: string; id?: string; name?: string; href?: string }
				project?: { key?: string; id?: string; name?: string; href?: string }
				customer?: { key?: string; id?: string; name?: string; href?: string }
				vendor?: { key?: string; id?: string; name?: string; href?: string }
				item?: { key?: string; id?: string; name?: string; href?: string }
				warehouse?: { key?: string; id?: string; name?: string; href?: string }
				class?: { key?: string; id?: string; name?: string; href?: string }
				task?: { id?: string; key?: string; name?: string; href?: string }
				costType?: { id?: string; key?: string; name?: string; href?: string }
				asset?: { id?: string; key?: string; name?: string; href?: string }
				contract?: { id?: string; key?: string; name?: string; href?: string }
				affiliateEntity?: {
					key?: string
					id?: string
					href?: string
					name?: string
				}
			}
			audit?: {
				createdDateTime?: string
				modifiedDateTime?: string
				createdBy?: string
				modifiedBy?: string
			}
		}[]
		creditCardLines?: {
			key?: string
			id?: string
			rateTable?: { key?: string; id?: string; name?: string; href?: string }
			href?: string
			lineNumber?: number
			description?: string
			startDate?: string
			markupPercent?: string
			accumulationType?: { key?: string; id?: string; href?: string }
			standardCostType?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			standardTask?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			dimensions?: {
				location?: { key?: string; id?: string; name?: string; href?: string }
				department?: {
					key?: string
					id?: string
					name?: string
					href?: string
				}
				employee?: { key?: string; id?: string; name?: string; href?: string }
				project?: { key?: string; id?: string; name?: string; href?: string }
				customer?: { key?: string; id?: string; name?: string; href?: string }
				vendor?: { key?: string; id?: string; name?: string; href?: string }
				item?: { key?: string; id?: string; name?: string; href?: string }
				warehouse?: { key?: string; id?: string; name?: string; href?: string }
				class?: { key?: string; id?: string; name?: string; href?: string }
				task?: { id?: string; key?: string; name?: string; href?: string }
				costType?: { id?: string; key?: string; name?: string; href?: string }
				asset?: { id?: string; key?: string; name?: string; href?: string }
				contract?: { id?: string; key?: string; name?: string; href?: string }
				affiliateEntity?: {
					key?: string
					id?: string
					href?: string
					name?: string
				}
			}
			audit?: {
				createdDateTime?: string
				modifiedDateTime?: string
				createdBy?: string
				modifiedBy?: string
			}
		}[]
		employeeExpenseLines?: {
			key?: string
			id?: string
			rateTable?: { key?: string; id?: string; name?: string; href?: string }
			href?: string
			lineNumber?: number
			description?: string
			startDate?: string
			markupPercent?: string
			accumulationType?: { key?: string; id?: string; href?: string }
			standardCostType?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			standardTask?: {
				key?: string
				id?: string
				name?: string
				href?: string
			}
			dimensions?: {
				location?: { key?: string; id?: string; name?: string; href?: string }
				department?: {
					key?: string
					id?: string
					name?: string
					href?: string
				}
				employee?: { key?: string; id?: string; name?: string; href?: string }
				project?: { key?: string; id?: string; name?: string; href?: string }
				customer?: { key?: string; id?: string; name?: string; href?: string }
				vendor?: { key?: string; id?: string; name?: string; href?: string }
				item?: { key?: string; id?: string; name?: string; href?: string }
				warehouse?: { key?: string; id?: string; name?: string; href?: string }
				class?: { key?: string; id?: string; name?: string; href?: string }
				task?: { id?: string; key?: string; name?: string; href?: string }
				costType?: { id?: string; key?: string; name?: string; href?: string }
				asset?: { id?: string; key?: string; name?: string; href?: string }
				contract?: { id?: string; key?: string; name?: string; href?: string }
				affiliateEntity?: {
					key?: string
					id?: string
					href?: string
					name?: string
				}
			}
			audit?: {
				createdDateTime?: string
				modifiedDateTime?: string
				createdBy?: string
				modifiedBy?: string
			}
		}[]
	} & { id?: {} }
) {
	const url = new URL(`https://api.intacct.com/ia/api/v1/objects/construction/rate-table/${key}`)

	const response = await fetch(url, {
		method: 'PATCH',
		headers: {
			'Content-Type': 'application/json',
			Authorization: 'Bearer ' + auth.token
		},
		body: JSON.stringify(body)
	})
	if (!response.ok) {
		const text = await response.text()
		throw new Error(`${response.status} ${text}`)
	}
	return await response.json()
}
Submitted by hugo697 235 days ago
← Back to the list of replies