Mashup Error when using API's

The update datasource transaction is missing the mandatory fields property. Only values that are changed will be passed to the update transaction so you need to tell the mashup what fields are the keys (mandatory). You don't need to add CONO since Smart Office will use your current company automatically.
Program="MMS200MI" Transaction="UpdItmBasic" Type="Update" InputFields="ITNO,ITDS" MaxReturnedRecords="1" MandatoryFields="ITNO" />

Hi Karin,

 

Thank you for your response.

 

But its not clear what you want me to do. what i have done so far is the code retrieves data from MMS200MI API to get information from M3. now what i need to do is do necessary changes in the required fields and update data through Mashup. i need assistance for that purpose. given below is the new code for your perusal. appreciate your assistance in this regard. 

 

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:ui="clr-namespace:Mango.UI.Controls;assembly=Mango.UI" xmlns:mashup="clr-namespace:Mango.UI.Services.Mashup;assembly=Mango.UI" xmlns:m3="clr-namespace:MForms.Mashup;assembly=MForms">
   
   

   
      Width="1*" />
      Width="4*" />
   
   
      Height="3*" />
      Height="2*" />
   

<!-- An example of an optional menu bar, could be removed if no menu bar will be used -->
   <!--
   
                Style="{DynamicResource styleBackgroundApplicationBarMashup}">
      

         
            
            
            
         
      
   
   -->
   Name="FINALTEST" IsListHeaderVisible="True" IsListHeaderReadOnly="True" Grid.Column="0" Grid.Row="0" Header="ITEM MASTER">
      
         
            SourceEventName="Startup">
               arameter TargetKey="MMCONO" />
               arameter TargetKey="MMITNO" />
            
         
      
      
         Program="MMS001" Table="MITMAS" KeyNames="MMCONO,MMITNO" SortingOrder="1" />
      
   
   Name="FINALTEST1" IsListHeaderVisible="True" IsListHeaderReadOnly="True" Grid.Column="0" Grid.Row="1" Header="ITEMWAREHOUSE">
      
         
            SourceName="FINALTEST" SourceEventName="CurrentItemChanged">
               arameter TargetKey="MBCONO" />
               arameter TargetKey="MBWHLO" />
               arameter TargetKey="MBITNO" />
            
         
      
      
         Program="MMS002" Table="MITBAL" KeyNames="MBCONO,MBWHLO,MBITNO" SortingOrder="2" />
      
   
   Name="ITEMUPDATE" Grid.Column="1" Grid.Row="0" Grid.RowSpan="2">

      

         
            
               Height="5*" />
               Height="1*" />
               Height="2*" />
            
            
               Width="1*" />
            
            Grid.Row="0" Grid.Column="0" Name="GETITEMBASIC">
               
                  
                     SourceName="FINALTEST" TargetName="GETITEMBASIC" SourceEventName="CurrentItemChanged" TargetEventName="Get">
                        arameter SourceKey="MMCONO" TargetKey="CONO" />
                        arameter SourceKey="MMITNO" TargetKey="ITNO" />
                     
                  
               
               
                  Program="MMS200MI" Transaction="GetItmBasic" Type="Get" InputFields="ITNO,CONO" OutputFields="ITNO,ITDS,FUDS,RESP,ITGR,GRP1,GRP2,GRP3,GRP4,GRP5,HIE2,CFI1,CFI5,WAPC,CHCD,BUAR,UNMS,PRGP,ALUC" />
               
               
                  
                     Width="Auto" />
                     Width="8" />
                     Width="200" />
                     Width="16" />
                     Width="Auto" />
                     Width="8" />
                     Width="200" />
                     Width="16" />
                     Width="*" />
                  
                  
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                  
                  Content="Item number:" Grid.Row="0" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="15" Text="{Binding [ITNO]}" Grid.Row="0" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Name:" Grid.Row="1" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="30" Text="{Binding [ITDS]}" Grid.Row="1" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Description 2:" Grid.Row="2" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="60" Text="{Binding [FUDS]}" Grid.Row="2" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Responsible:" Grid.Row="3" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="10" Text="{Binding [RESP]}" Grid.Row="3" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Basic unit of measure:" Grid.Row="4" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="3" Text="{Binding [UNMS]}" Grid.Row="4" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Item group:" Grid.Row="5" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="8" Text="{Binding [ITGR]}" Grid.Row="5" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Business area:" Grid.Row="6" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="3" Text="{Binding [BUAR]}" Grid.Row="6" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Configuration code:" Grid.Row="7" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="1" Text="{Binding [CHCD]}" Grid.Row="7" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Normal waste percentage:" Grid.Row="8" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="7" Text="{Binding [WAPC]}" Grid.Row="8" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Hierachy level 2:" Grid.Row="9" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="15" Text="{Binding [HIE2]}" Grid.Row="9" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Search group 1:" Grid.Row="0" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="15" Text="{Binding [GRP1]}" Grid.Row="0" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Search group 2:" Grid.Row="1" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="15" Text="{Binding [GRP2]}" Grid.Row="1" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Search group 3:" Grid.Row="2" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="15" Text="{Binding [GRP3]}" Grid.Row="2" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Search group 4:" Grid.Row="3" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="15" Text="{Binding [GRP4]}" Grid.Row="3" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Search group 5:" Grid.Row="4" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="15" Text="{Binding [GRP5]}" Grid.Row="4" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="User-defined field 1 - item:" Grid.Row="5" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="10" Text="{Binding [CFI1]}" Grid.Row="5" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="User-defined field 5 - item:" Grid.Row="6" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="1" Text="{Binding [CFI5]}" Grid.Row="6" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Procurement group:" Grid.Row="7" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="3" Text="{Binding [PRGP]}" Grid.Row="7" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Alternate U/M in use:" Grid.Row="8" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="1" Text="{Binding [ALUC]}" Grid.Row="8" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
               
            

            Name="GETITMPRICE" Grid.Column="0" Grid.Row="1">
               
                  
                     SourceName="FINALTEST" SourceEventName="CurrentItemChanged" TargetName="GETITMPRICE" TargetEventName="Get">
                        arameter SourceKey="MMCONO" TargetKey="CONO" />
                        arameter SourceKey="MMITNO" TargetKey="ITNO" />
                     
                  
               
               
                  Program="MMS200MI" Transaction="GetItmPrice" Type="Get" InputFields="CONO,ITNO" OutputFields="PUPR,PUCD,ECCC" />
               
               
                  
                     Width="Auto" />
                     Width="8" />
                     Width="200" />
                     Width="16" />
                     Width="Auto" />
                     Width="8" />
                     Width="200" />
                     Width="16" />
                     Width="*" />
                  
                  
                     Height="Auto" />
                     Height="Auto" />
                  
                  Content="Consumption code - trade stat (TST):" Grid.Row="0" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="4" Text="{Binding [ECCC]}" Grid.Row="0" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Purchase price:" Grid.Row="1" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="19" Text="{Binding [PUPR]}" Grid.Row="1" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Purchase price quantity:" Grid.Row="0" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="5" Text="{Binding [PUCD]}" Grid.Row="0" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
               
            
            Name="GETITEMWH" Grid.Column="0" Grid.Row="2">
               
                  
                     SourceName="FINALTEST1" TargetName="GETITEMWH" TargetEventName="Get" SourceEventName="CurrentItemChanged">
                        arameter SourceKey="MBITNO" TargetKey="ITNO" />
                        arameter SourceKey="MBWHLO" TargetKey="WHLO" />
                     
                  
               
               
                  Program="MMS200MI" Transaction="GetItmWhsBasic" Type="Get" InputFields="WHLO,ITNO" OutputFields="RESP,BUYE,SUNO,LEAT,UNMU,EQDA" />
               
               
                  
                     Width="Auto" />
                     Width="8" />
                     Width="200" />
                     Width="16" />
                     Width="Auto" />
                     Width="8" />
                     Width="200" />
                     Width="16" />
                     Width="*" />
                  
                  
                     Height="Auto" />
                     Height="Auto" />
                     Height="Auto" />
                  
                  Content="Responsible:" Grid.Row="0" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="10" Text="{Binding [RESP]}" Grid.Row="0" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Buyer:" Grid.Row="1" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="10" Text="{Binding [BUYE]}" Grid.Row="1" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Supplier number:" Grid.Row="2" Grid.Column="0" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="10" Text="{Binding [SUNO]}" Grid.Row="2" Grid.Column="2" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Economical order quantity days:" Grid.Row="0" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="3" Text="{Binding [EQDA]}" Grid.Row="0" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Lead time:" Grid.Row="1" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="3" Text="{Binding [LEAT]}" Grid.Row="1" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
                  Content="Order multiple:" Grid.Row="2" Grid.Column="4" HorizontalAlignment="Left" VerticalAlignment="Center" />
                  MaxLength="17" Text="{Binding [UNMU]}" Grid.Row="2" Grid.Column="6" HorizontalAlignment="Stretch" VerticalAlignment="Center" />
               
            
         
      
   

 

Hi,

Perhaps it will be more clear if you check my answer to Priyanthas question in the comments section on this blog post: on https://smartofficeblog.c...he-mashup-designer/.

Hi Karin,

Thanks for the response.

i have tried that, but it throws errors. so i decided to look for another option. the way am working is i need to many get API's to update many API's. so the code needs the update option. appreciate your assistance in this regard.

Hi,

I'm afraid I can't assist and build your mashup. I can assist and answer questions. In your latest example (which I cannot use directly since all leading < is removed) the UpdItmBasic transaction is missing. The basic idea is that all values you have retrieved in the scope of the panel can be used in an update transaction. However the update will try and be smart and only send in those fields that are selected as input fields - but they need to be changed. So a common issue is that the fields that are mandatory needs to be set on the data source as "MandatoryFields". To trigger the update you need a button to send the update event to the control. I suggest that you look at the Customers sample in the Mashup Designer and browse for more examples on my blog or that you see if there are any Infor courser that you can take to learn more.

Please note that you wrote in the first post that "There is an error" - what exactly is the error from the update call? Have you turned on the debug check box to verify that the values you need for the update transaction is present in the event that triggers the update?

HI Karin,

 

Thank You for your response!

Their seems to some values missing when the copy & paste is done.

 is their another way for me to share the code?, then you may get a better idea of what am trying.