Table not updating with form
The Table service offers structured storage in the form of tables.
What is more complicated is the following scenario: update the Payment Terms for each customer based on a list in Excel.
These identifiers may not be used in property names, because property names are sent via an XML payload in a request against the Table service.
Important Property names are passed to the Table service within a URL.
You can either do that inside the GP application itself, or check the SY03300 table, which is probably more efficient and will also check for any typos: select * from ( select 'AARONFIT0001' customer, 'Net 30' terms union select 'ADAMPARK0001' customer, 'Net 30' terms union select 'ADVANCED0001' customer, 'Net 15' terms union select 'ADVANCED0002' customer, 'Net 30' terms union select 'ALTONMAN0001' customer, '2% 10/Net 30' terms union select 'AMERICAN0001' customer, 'Net 45' terms ) a where terms not in (select PYMTRMID from SY03300) Notice that I simply took what I copied into SQL from Excel and made it into a table by putting parentheses around it and adding an alias (a) at the end.
If all is well, the query above should come back with no results.