Powershell/XML saving returned value and multiple scripts

Question

I've written XML code to open a ticket in Autotask and inserted it into a PowerShell script because it needs to be automated. The script creates a ticket and I need to save a value that the create ticket function returns so I can then update it in the same script. Is there a way to

run a create ticket HTTP POST request subsequently followed by an update request in the same script, and
somewhere in between the scripts save the value that is returned by the create ticket script, and then use it as a variable in the update ticket script?

$RequestBody = @"


  
    
    
  
  
    
      
        
        all my entities
        
      
    
  

"@

Invoke-WebRequest -Uri $AUTOTASK -Method Post -Body $RequestBody -ContentType $ContentType -UseBasicParsing -Headers $Headers;

$id = @""@  # The field I want to save and insert later is returned as 

$UpdateBody = @"


  
    
    
  
  
    
      
        
           all my entities
           $id
        
      
    
  

"@

Invoke-WebRequest -Uri $AUTOTASK -Method Post -Body $UpdateBody -ContentType $ContentType -UseBasicParsing -Headers $Headers;

The headers were left out on purpose due to them containing sensitive info.

EDIT: Here is the response to the request:


  
    
      
        1
        
          
            12345
             
              Escalated Internally?
              Ticket Category
              Escalated by Customer?
              Initial Severity
              Incident Start Date/Time

It's just a giant block of fields. In there is a field called whose value is an integer, which is what I need.

EDIT 2:
Updated Code

$RequestBody = @"



  
    
    
  
  
    
      
        
          123
          123
          09/30/18
          $Title
          123
          123
          123
          123
         
      
    
  

"@

$rsp = Invoke-WebRequest -Uri $AUTOTASK -Method Post -Body $RequestBody -ContentType $ContentType -UseBasicParsing -Headers $Headers;
$ticketno = $rsp.ResponseXml.Envelope.Body.createResponse.createResult.EntityResults.Entity.id;

$UpdateBody = @"


  
    
    
  
  
    
      
        
          123
          Success
          123
          123
          $ticketno
          09/30/18
          123
        
      
    
  

"@

Invoke-WebRequest -Uri $AUTOTASK -Method Post -Body $UpdateBody -ContentType $ContentType -UseBasicParsing -Headers $Headers;

Error response:

Invoke-WebRequest : soap:ClientSystem.Web.Services.Protocols.SoapException:
Server was unable to read request. ---> System.InvalidOperationException:
There is an error in XML document (15, 20). ---> System.FormatException:
Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Int64.Parse(String s, NumberStyles style, IFormatProvider provider)
   at System.Xml.XmlConvert.ToInt64(String s)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read201_Ticket(Boolean isNullable, Boolean checkType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read5_Entity(Boolean isNullable, Boolean checkType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReader1.Read253_update()
   at Microsoft.Xml.Serialization.GeneratedAssembly.ArrayOfObjectSerializer44.Deserialize(XmlSerializationReader reader)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   --- End of inner exception stack trace ---
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at System.Web.Services.Protocols.SoapServerProtocol.ReadParameters()
   --- End of inner exception stack trace ---
   at System.Web.Services.Protocols.SoapServerProtocol.ReadParameters()
   at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
At C:\Users\Marc\Documents\StoredValue.ps1:86 char:1
+ Invoke-WebRequest -Uri $AUTOTASK -Method Post -Body $UpdateBody -Cont ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     + CategoryInfo          : InvalidOperation: (Method: POST, R...pe: text/xml}:HttpRequestMessage) [Invoke-WebRequest], HttpResponseException
     + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommand

EDIT 3:

Result of $rsp | Get-Member

       TypeName: Microsoft.PowerShell.Commands.BasicHtmlWebResponseObject

Name              MemberType Definition
----              ---------- ----------
Equals            Method     bool Equals(System.Object obj)
GetHashCode       Method     int GetHashCode()
GetType           Method     type GetType()
ToString          Method     string ToString()
BaseResponse      Property   System.Net.Http.HttpResponseMessage BaseResponse {get;set;}
Content           Property   string Content {get;}
Encoding          Property   System.Text.Encoding Encoding {get;}
Headers           Property   System.Collections.Generic.Dictionary[string,System.Collections.Generic.IEnumerable[string]] Headers {get;}
Images            Property   Microsoft.PowerShell.Commands.WebCmdletElementCollection Images {get;}
InputFields       Property   Microsoft.PowerShell.Commands.WebCmdletElementCollection InputFields {get;}
Links             Property   Microsoft.PowerShell.Commands.WebCmdletElementCollection Links {get;}
RawContent        Property   string RawContent {get;set;}
RawContentLength  Property   long RawContentLength {get;}
RawContentStream  Property   System.IO.MemoryStream RawContentStream {get;}
RelationLink      Property   System.Collections.Generic.Dictionary[string,string] RelationLink {get;}
StatusCode        Property   int StatusCode {get;}
StatusDescription Property   string StatusDescription {get;}

Powershell/XML saving returned value and multiple scripts

Answers (1)

Related Questions