APCHEKDA APCHEKDT APCHEKHA APCHEKHT APCONTMM APIMPOHT APINVODA APINVODT APINVOHA APINVOHT APOPENST APRECUDT APRECUHT APREMIMM APSYSTEM APTERMMM APVENDMM APVEXPDT	ARAGEDST ARCARDDT ARCARDMM ARCASHDA ARCASHDT ARCASHHA ARCASHHT ARCICSMM ARCOMMMM ARCONTDT ARCONTMM ARCOUNMM ARCTYPMM ARCUSTMM ARDEFAMM ARDEPOHA ARDEPOHT ARGLACHM ARINVODA ARINVODT ARINVOHA ARINVOHT ARMISCMM AROPENST ARPAYMMM ARQUIKDT ARQUIKHT ARRECUDT ARRECUHT ARREPSDT ARSHIPDT ARSLSMDA ARSLSMDT ARSLSMH1 ARSLSMHA ARSLSMMM ARSRCEMM ARSTYPMM ARSYSTEM ARTAXMM ARTERMMM	BRCLEADA BRJOURDA BRJOURHA BRMISCMM BRRECODA BRRECODT BRRECOHA BRRECOHT BRSYSTEM	CMFPREDT CMLPREDT CMLSUFDT CMREFEDT CMREGADT CMSYSTEM CMTYPEDT CMTYPXDT	CPSYSTEM	CTBOLMNT CTCONTDT CTCONTMM CTDESTMM CTSHIPMM CTSIZEMM CTSYSTEM
FHJOURDT FHJOURHA FSCLASS FSDIV FSFSCOST FSFSGRP FSPERIOD FSSUBCL FSTYPE FSWORK GLACCODT GLACCOHM GLACCTMP GLBANKMM GLBUDGHT GLBUDGMM GLCOLDT GLCOLHT GLDEPTMM GLFINADT GLFINAHT GLIMPOHT GLJOURDA GLJOURDT GLJOURHA GLJOURHT GLJOURMM GLPERIDT GLPLRECO GLRANGDT GLRANGHT GLRECUDT GLRECUHT GLSCHDT GLSCHHT GLSYSTDT GLSYSTEM GLTRNTMP	INALTEDT INALTEHT INASSEDT INASSEMM INBINLDT INBINSDA INBINSDT INBINSMM INBINSST INBOXDT INBRANMM INCAREDT INCAREMM INCATEMM INCATWKS INCOLLMM INCOLOMM INCOMPDT INDEVEDT INDUTYMM INFINIMM INITEMDT INITEMHT INITEMMM INLEVEMM INMARKDT INMARKMM INMATEMM INMEMOMM INMKTGDT INMKTGMM INORDEHT INPACKDT INPACKMM INPARTDT INPARTMM INPHYSST INPRICMM INPRODMM INPURTRN INSCATMM INSCOLMM INSMCAMM INSPECDT INSPECMM INSTATMM INSYSTEM INTIERST INTRANDA INTRANDT INTRANHT INUMCOMM INVENDMM INWAREDT INWAREMM	IXITSGMM IXSEGMMM IXSYSTEM	MACOMMMM MAEMPLMM MALOTSDA MALOTSDT MAMISCMM MAOPTIDT MAOPTSDT MAORDE1A MAORDED1 MAORDEDA MAORDEDT MAORDEHA MAORDEHT MAPRODDT MAROUTDT MASYSTEM MATRANDT MAWIPE1A MAWIPED1 MAWIPEDA MAWIPEDT MAWIPEHT MAWORKMM	MMFAXDT MMSYSTEM	PODEPODA PODEPODT POITEMMM POLOTSDA POLOTSDT POMISCMM POORDEDA POORDEDT POORDEHA POORDEHT POPRICMM POPURCDT POPURTRN POSHIPMM POSVIAMM POSYSTEM POTRANDT
PSDRAWDT PSSYSTDT PSSYSTEM PSUSERDT	SFBOLMNT SFCONTMM SFSCA2DA SFSCA2DT SFSCA2HA SFSCA2HT SFSCANDA SFSCANDT SFSCANHA SFSCANHT SFSHIPMM SFSYSTEM	SOAUTHMM SOBINLDT SOCHANMM SODELEDT SODEPODA SODEPODT SOIMPOHT SOLOTSDA SOLOTSDT SOORDEDA SOORDEDT SOORDEHA SOORDEHT SORETUMM SOROYADA SOROYADT SOSALEHA SOSHIPMM SOSHPORD SOSVIADT SOSVIAHT SOSYSTEM SOTAXCDA SOTAXCDT SOTRANDT SOUPSTDT	TBCUSTMM TBEMPLMM TBINVDTE TBRATEDT TBSERVMM TBSYSTEM TBTIMEMM	WMCYCLDT WMCYCLHT WMORDEDA WMORDEDT WMREASMM WMSCANDA WMSCANDT WMSCANHA WMSCANHT WMSERIAL WMSYSTDT WMSYSTEM

Proper format for a date in any Get or Update is YYYY-MM-DD. Each database has a two letter designation at the end of the title above. Please use that designation for any database request. Above you will find the database and if you scroll over the database it will list each table associated. Clicking on the table will give details about the selected table.

Method: GetAllRecords

This method allows you to get data from any table. If you pass the FieldName and Data parameters the returned data will be filtered.

Parameters: Database - String - Required - Please refer to valid databases above; TableName - String - Required - Please refer to valid tablenames above; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed; FieldName - String - Optional - Refer to database above for field lists; Data - String - Optional - The data you want to query
Example Queries: With Query:
https://localhost:(port)/ws_virtualgolden/GetAllRecords?Database=&TableName=&GUsername=&GPassword=&FieldName=&Data=; Without Query:
https://localhost:(port)/ws_virtualgolden/GetAllRecords?Database=&TableName=&GUsername=&GPassword=
Response: JSON Formatted string of request

Method: GetPagedData

This method allows you to get data from any table in a paged manner. For instance if you have one hundred records and want to break them down to five groups of 20 records for quicker data retreival. You must pass PagedStart and PagedEnd. Each record is assigned a RECNO value this can be seen at the end of the data.

Parameters: Database - String - Required - Please refer to valid databases above; TableName - String - Required - Please refer to valid tablenames above; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed; PagedStart - Integer - Required - This is the first RecordNumber (RECNO); PagedEnd - Integer - Required - This is the last RecordNumber (RECNO)
Example Queries: Without Query:
https://localhost:(port)/ws_virtualgolden/GetPagedData?Database=&TableName=&GUsername=&GPassword=&PagedStart=&PagedEned=
Response: JSON Formatted string of request

Method: InsertRecord

This method is used to create new records. Providing the parameters below will add the record to the expected table. The JSON string should include all related fields. The JSON string can not be an array.

Parameters: Database - String - Required - Please refer to valid databases above; TableName - String - Required - Please refer to valid tablenames above; JSONString - String - Passed as Post Data - Required - JSON formatted string of the data to be inserted. Should follow the field names for the table; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/Insert?Database=&TableName=&GUsername=p&GPassword=
Response: Insert Successful; Insert Unsuccesful

Method: Update

This method is used to update an existing record. The JSON string should include all related fields. The JSON string can not be an array.

Parameters: Database - String - Required - Please refer to valid databases above; TableName - String - Required - Please refer to valid tablenames above; JSONString - String - Passed as Post Data - Required - JSON formatted string of the data to be inserted. Should follow the field names for the table; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/Update?Database=&Tablename=&GUsername=&GPassword=
Response: Update Successful; Update Unsuccesful

Method: GetRecordCount

This method is used to provide a count of all records in a table.

Parameters: Database - String - Required - Please refer to valid databases above; TableName - String - Required - Please refer to valid tablenames above; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/GetRecordCount?Database=&Tablename=&GUsername=&GPassword=
Response: Numeric value

Method: CustomerOpenAR

This method returns a specfic customers open accounts receivable regardless of past due. Thier owed amount for all open invoices.

Parameters: CustomerNumber - String - Required - Golden customer number; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/CustomerOpenAR?CustomerNumber=&GUsername=&GPassword=
Response: String value of current Open Accounts Receivable

Method: CustomerOpenARDays

This method returns a specfic customers open accounts receivable. When you pass the days parameter it will limit the data to the invoice older then the days provided. Thier owed amount for all open invoices.

Parameters: CustomerNumber - String - Required - Golden customer number; Days - String - Required - Days to age valid responses are (0, 30, 60, 90, 120); GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/CustomerOpenARDays?CustomerNumber=&Days=&GUsername=&GPassword=
Response: String value of current Open Accounts Receivable based on aging days

Method: CustomerStatement

This method provides the same information as Customer Open AR.

Parameters: CustomerNumber - String - Required - Golden customer number; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/CustomerStatement?CustomerNumber=&GUsername=&GPassword=
Response: JSON formatted string of request

Method: CustomerStatementDays

This method provides the same information as Customer Open AR Days.

Parameters: CustomerNumber - String - Required - Golden customer number; Days - String - Required - Days to age valid responses are (0, 30, 60, 90, 120); GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/CustomerStatementDays?CustomerNumber=&Days=&GUsername=&GPassword=
Response: JSON formatted string of request based on aging days

Method: QuantityAvailable

This method provides an items quantity available based on the calculation indicated in Golden. If you pass the optional warehousecode parameter it will limit the data to the specific warehouse.

Parameters: ItemNumber - String - Required - Golden inventory item number; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed; WarehouseCode - String - Optional - Warehouse code from Golden
Example Queries: https://localhost:(port)/ws_virtualgolden/QuantityAvailable?ItemNumber=&GUsername=&GPassword=; https://localhost:(port)/ws_virtualgolden/QuantityAvailable?ItemNumber=&GUsername=&GPassword=&WarehouseCode=
Response: String value of current available quantity based on Golden calculation

Method: OpenSalesOrder

This method will provide the header information for any sales order for the customer specified. If you provide the optional ordertype paremeter it will limit the data.

Parameters: CustomerNumber - String - Required - Golden customer number; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed; OrderType - String - Optional - Golden ordertype (S, B, Q, I)
Example Queries: https://localhost:(port)/ws_virtualgolden/OpenSalesOrder?CustomerNumber=&GUsername=&GPassword=
Response: JSON formatted string of request based on aging days

Method: GetCustomerRange

Using the method will allow to get all customers in the specified range.

Parameters: sCustomerNumber - String - Required - First number in range Golden customer number; eCustomerNumber - String - Required - Last number in range Golden customer number; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/GetCustomerRange?sCustomerNumber=&eCustomerNumber=&GUsername=&GPassword=
Response: JSON formatted string of requested customer data

Method: GetSalesOrderRange

This method allows you to pull open sales orders in a range.

Parameters: sOrderNumber - String - Required - First number in range Golden order number; eOrderNumber - String - Required - Last number in range Golden order number; GUsername - String - Required - Golden username must be passed and valid from the Golden users database; GPassword - String - Required - Golden password for qualifying username must be passed
Example Queries: https://localhost:(port)/ws_virtualgolden/GetSalesOrderRange?sOrderumber=&eOrderNumber=&GUsername=&GPassword=
Response: JSON formatted string of requested sales order data