Returns data from the BudgetItems table.

Table Specific Information

SELECT

The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:

• Id supports =
• Deleted supports =,!=
• CostType supports =,!=
• Status supports =,!=
• Date supports >,<,>=,<=
• EventId supports =,!=
• CategoryId supports =,!=
• CategoryName supports =,!=
• SubcategoryId supports =,!=
• SubcategoryName supports =,!=
• VendorId supports =,!=
• VendorName supports =,!=

All other filters are handled client-side.

The following is an example of a SELECT statement:

select * from BudgetItems where Id='cventId' or Date <= '06/11/2020'

INSERT

The following is an example of an INSERT statement that uses an aggregate field:

String costDetail = '[ 
              { 
                \id\: \281d7a8b-f525-4658-9268-5ea73c97a54e\, 
                ame\: \Budgeted\, 
                \units\: 1.0, 
                \cost\: 500.0, 
                \gratuityDetail\: { 
                  \gratuity\: 0.0, 
                  \appliedGratuityValue\: 0.0 
                }, 
                \taxDetail\: [], 
                \totalCost\: 500.0 
              }, 
              { 
                \id\: \d8cbab1a-e370-43b9-afde-a097c81e20e1\, 
                ame\: egotiated\, 
                \units\: 1.0, 
                \cost\: 400.0, 
                \gratuityDetail\: { 
                  \gratuity\: 0.0, 
                  \appliedGratuityValue\: 0.0 
                }, 
                \taxDetail\: [], 
                \totalCost\: 400.0 
              }, 
              { 
                \id\: \0ca4467a-5843-4204-8c26-452680b04b27\, 
                ame\: \Revision1\, 
                \units\: 1.0, 
                \cost\: 424.0, 
                \gratuityDetail\: { 
                  \gratuity\: 0.0, 
                  \appliedGratuityValue\: 0.0 
                }, 
                \taxDetail\: [], 
                \totalCost\: 424.0 
              }, 
              { 
                \id\: \10cc5cef-a4f3-4474-bb9d-0c0c7110b351\, 
                ame\: \Revision2\, 
                \units\: 1.0, 
                \cost\: 455.0, 
                \gratuityDetail\: { 
                  \gratuity\: 0.0, 
                  \appliedGratuityValue\: 0.0 
                }, 
                \taxDetail\: [], 
                \totalCost\: 455.0 
              }, 
              { 
                \id\: \2eec2b68-808d-4bab-a061-b4fafc3300dc\, 
                ame\: \Actual\, 
                \units\: 1.0, 
                \cost\: 455.0, 
                \gratuityDetail\: { 
                  \gratuity\: 0.0, 
                  \appliedGratuityValue\: 0.0 
                }, 
                \taxDetail\: [], 
                \totalCost\: 455.0 
              } 
            ]';

INSERT INTO budgetitems (EventId, costType, name, Status, Date, costIncludesTaxGratuity, calculateTaxOnGratuity, gratuityType, currency, conversionRate, CategoryId, CategoryName, costDetailAggregate)
 VALUES('0ac85e1d-ef51-43a0-a4cf-773b64b1c6f9', 'FIXED', 'Airport Transportation', 'ESTIMATED', '2020-02-07T00:00:00.00Z', false, true, 'PERCENTAGE', 'USD', '5.2', '3', 'Travel', costDetail)

UPDATE

The following is an example of an UPDATE statement that uses an aggregate field:

Update BudgetItems SET  costType='FIXED', name='Airport Transportation', CategoryId='3',  
            CategoryName='Travel', status='PAID', date='2024-02-07T00:00:00.00Z', costIncludesTaxGratuity='false', 
             calculateTaxOnGratuity='true' , gratuityType='PERCENTAGE', currency='USD', conversionRate='5.2',costDetailAggregate=costDetail    
            where  EventId='0ac85e1d-ef51-43a0-a4cf-773b64b1c6f9' and id='eb07a054-71a5-49a5-9773-064c3b9ec507'

Columns

Name	Type	ReadOnly	References	Description
Deleted	Boolean	False		The Deleted of the BudgetItems table.
Id [KEY]	String	False		The Id of the BudgetItems table.
CostType	String	False		The CostType of the BudgetItems table.
Name	String	False		The Name of the BudgetItems table.
Code	String	False		The Code of the BudgetItems table.
Status	String	False		The Status of the BudgetItems table.
Date	Datetime	False		The Date of the BudgetItems table.
LastModifiedDate	Datetime	False		The LastModifiedDate of the BudgetItems table.
CostIncludesTaxGratuity	Boolean	False		The CostIncludesTaxGratuity of the BudgetItems table.
CalculateTaxOnGratuity	Boolean	False		The CalculateTaxOnGratuity of the BudgetItems table.
GratuityType	String	False		The GratuityType of the BudgetItems table.
InternalNote	String	False		The InternalNote of the BudgetItems table.
Currency	String	False		The Currency of the BudgetItems table.
ConversionRateLocked	String	False		The ConversionRateLocked of the BudgetItems table.
ConversionRate	String	False		The ConversionRate of the BudgetItems table.
AssociatedSession	String	False		The AssociatedSession of the BudgetItems table.
CategoryId	String	False		The CategoryId of the BudgetItems table.
CategoryName	String	False		The CategoryName of the BudgetItems table.
SubCategoryId	String	False		The SubCategoryId of the BudgetItems table.
SubCategoryName	String	False		The SubCategoryName of the BudgetItems table.
VendorId	String	False		The VendorId of the BudgetItems table.
VendorName	String	False		The VendorName of the BudgetItems table.
VendorType	String	False		The VendorType of the BudgetItems table.
GeneralLedgerId	String	False		The GeneralLedgerId of the BudgetItems table.
GeneralLedgerCode	String	False		The GeneralLedgerCode of the BudgetItems table.
GeneralLedgerName	String	False		The GeneralLedgerName of the BudgetItems table.
CostAvoidanceAmount	Double	False		The CostAvoidanceAmount of the BudgetItems table.
CostAvoidanceDescription	String	False		The CostAvoidanceDescription of the BudgetItems table.
CostDetailAggregate	String	False		The CostDetailAggregate of the BudgetItems table.
SavingsAggregate	String	False		The SavingsAggregate of the BudgetItems table.
AssociatedRegistrantsAggregate	String	False		The AssociatedRegistrantsAggregate of the BudgetItems table.
EventId [KEY]	String	False	Events.Id	The EventId of the BudgetItems table.