Update-ERPMedia

Cmdlet to update the Media Resource of an existing streamable entity with a given media file.

Syntax

Update-ERPMedia [[-EntitySet] <String>] [[-File] <String>]] [[-Keys] <Object>] [[-ContentType] <String>]] [<CommonParameters>]

Parameters

Type

Name

Description

Optional

String

EntitySet

The EntitySet name where the Media Link Entity is located.
It is also possible to specify additional namespaces or the whole url (e.g MaterialService/Materials, http://localhost:8080/PGS/ERP/MaterialService/Materials)

no

Hashtable / PSObject

Keys

The reference properties for the entity beeing updated

no

String

File

Path to the file to upload

no

String

ContentType

Specifies the content type of the web request.
If no content type is provided, the cmdlet sets the content type depending on the file extension. (e.g .txt ⇒ ‘text/plain’, .pdf ⇒ ‘application/pdf’ …)

yes

Return type

Bool:
$true ← on success.
$false ← on failure. Exception/ErrorMessage can be accessed using $Error.
If the cmdlet fails due to error responses returned by the ERP system, the $Error variable provides a WebRequestException .

Remarks

The Cmdlet is used to update the Media Resource of an existing Media Link Entry (MLE) by uploading the specified file.

The ContentType is used to specify the nature of the file currently being handled. With the appropriate content type the web browser can open the file with the proper extension/plugin.

  • If no content type is set the Cmdlet will determine the content type depending on the file type.

  • If the content type contains text (e.g text/plain, text/html…) as type or json , xml (e.g application/json, application/xml…) as subtype, then the content of the file is uploaded to the server as UTF-8 Encoded text.

Examples

In the following example we are using the public OData Services (http://services.odata.org) for demonstration purposes:

Updating the Media Resource of a Media Link Entry (MLE)

Invoke-WebRequest -Uri 'https://randompokemon.com/sprites/normal/143.gif' -OutFile 'C:\Temp\TestMedia.gif'
Connect-Erp -Service "http://services.odata.org/V4/OData/(S(du4oaehbpzqh2eznhygi1xkg))/OData.svc"
Update-ERPMedia -EntitySet "Advertisements" -Keys @{ID=[Guid]'f89dee73-af9f-4cd4-b330-db93c25ff3c7'} -File 'C:\Temp\TestMedia.gif'

Note

The cmdlet automatically detects the ContentType of the file to be ‘image/gif’. The browser is able to use this information and directly show the image.
You can test the updated Media Resouce by clicking here.

In the following examples we are using a custom plugin for the powerGateServer :

Updating the Media Resource of a Media Link Entry (MLE) with specific ConentType and download it again

Invoke-WebRequest -Uri 'https://randompokemon.com/sprites/normal/6.gif' -OutFile 'C:\Temp\TestMedia.gif'
Connect-Erp -Service "http://localhost:8080/powerGate.Tests/TestService"
Update-ERPMedia -EntitySet "Files" -Keys @{"Id"=2} -File "C:\Temp\TestMedia.gif" -ContentType 'image/x-xbitmap'
Get-ERPMEdia -EntitySet "Files" -Keys @{Id=2} -File "C:\Temp\TestMedia_2.gif"

Error handling, analyze the WebRequestException why the Media Resource could not be updated, by using $Error

Connect-Erp -Service "https://services.odata.org/V3/(S(o2bnti0dqsoaosxxnt5pci1q))/OData/OData.svc/"
$result = Update-ERPMedia -EntitySet "Advertisements" -Keys @{"ID"=[guid]"f89dee73-af9f-4cd4-b330-db93c25ff3c7"} -File "C:\Temp\MyPictures\GT220 Change Proposal.png"

if(-not $result){
        $Error[0].Exception.StatusCode #413
        $Error[0].Exception.Message #"Request Entity Too Large"
}