cancel
Showing results for 
Search instead for 
Did you mean: 

How to use 'Post' in Gateway client for an empty table

JasonLu
Advisor
Advisor
0 Kudos

Hi All,

    I am facing a question that how to use 'Post' function in gateway client to add a line of data to an empty table? As some material mentioned I should use 'Get' first and then click the 'Use as Request' button to get the format but my entity is using an empty table so I cannot use the 'Get' function to get the format. Could anyone give me some advice about it? Thanks in advance.

Regards,

Zhengzhang

Accepted Solutions (0)

Answers (3)

Answers (3)

tharaka_fernando
Contributor

Dear Zhengzhang,

As per Ekansh said you can manually generate the payload in GW Client. You may get the structure of your variables using "$metadata" option and generate the payload as per above..Put the URI and click "post" option.

Former Member

If you don't have a GET, how do you intend to verify the data that is posted?

EkanshCapgemini
Active Contributor

You can manually create the payload that contains the data you want to insert into the table. This payload will consist of the properties of your entity.

You can check the sample payload below:


<?xml version="1.0" encoding="UTF-8"?>

<atom:entry xmlns:atom="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

   <atom:content type="application/xml">

      <m:properties>

            <d:ConfNo>0000003327</d:ConfNo>

            <d:Orderid>000004000655</d:Orderid>

            <d:Operation>0010</d:Operation>

            <d:FinConf></d:FinConf>

            <d:Complete></d:Complete>

            <d:ClearRes></d:ClearRes>

            <d:DevReason></d:DevReason>

            <d:ConfText></d:ConfText>

            <d:Plant>1500</d:Plant>

            <d:WorkCntr>TECH01</d:WorkCntr>

            <d:ActWork>2.0</d:ActWork>

            <d:UnWork>STD</d:UnWork>

            <d:RemWork>55.0</d:RemWork>

            <d:UnRemWrk>STD</d:UnRemWrk>

            <d:PersNo>00000000</d:PersNo>

            <d:ActType>TECH</d:ActType>

      </m:properties>

   </atom:content>

</atom:entry>

This can be used to insert first line into your table.