Search results by user ID 6118

Re: HTTP Post an array?

nsmith_piano — Tue, 01 Oct 2013 01:56:21 GMT

Here is my Python:

import webapp2
import urllib
from google.appengine.api import urlfetch

class MainHandler(webapp2.RequestHandler):

   def get(self):
       self.response.headers['Content-Type'] = 'text/plain'

       url = 'https://www.methodintegration.com/MethodAPI/service.asmx/MethodAPIInsertV2'
       form_fields = {
          "strCompanyAccount": "myAccount",
          "strLogin": "myUser",
          "strPassword": "myPassword",
          "strSessionID": "",
          "strTable":"Campaign",
          "arrInsertFieldsArray": ["Name","AssignedTo"],
          "arrInsertValueArray": ["Test","Randy"],
       }
       form_data = urllib.urlencode(form_fields)
       result = urlfetch.fetch(url=url,
           payload=form_data,
           method=urlfetch.POST,
           headers={'Content-Type': 'application/x-www-form-urlencoded'})
       self.response.write('posted: ' + form_data + '<br/>result is now: ' + result.content)


app = webapp2.WSGIApplication([
    ('/', MainHandler)
], debug=True)

It is posting this:

arrInsertFieldsArray=%5B%27Name%27%2C+%27AssignedTo%27%5D&strSessionID=&strPassword=myPassword&strCompanyAccount=myAccount&strTable=Campaign&strLogin=myPassword&arrInsertValueArray=%5B%27APICampaign%27%2C+%27Randy%27%5D

The response content is:

It does not appear the field '['Name', 'AssignedTo']' exists in the table.

Re: HTTP Post an array?

nsmith_piano — Mon, 30 Sep 2013 18:16:23 GMT

Thanks for your response Dave.

I am hoping to use Google App Engine with Python. I am using the urllib.urlencode() function. In my dictionary I have {arrInsertFieldArray : ['name', 'assignedTo']}. I pass the dictionary to urlencode() and send the resulting string to Method, but I am not getting a good response. I don't have my app in front of me now. I'll post specific examples later.

The content type in the post example in the documentation is x-www-form-urlencoded. I understand that content to be form data encoded as name/value pairs, similar to a URI query string.

If there is one name "arrInsertFieldArray" and multiple values in an array, how would the Method server like to receive multiple values?

I was able to get my app to talk to Method in simple requests like MethodAPITableListV2 that only reqired single-valued parameters.

Re: Trouble deleting records in other table

nsmith_piano — Mon, 30 Sep 2013 14:18:29 GMT

That's great news. Thanks for your help.

HTTP Post an array?

nsmith_piano — Mon, 30 Sep 2013 00:01:51 GMT

The information at https://www.methodintegration.com/MethodAPI/service.asmx?op=MethodAPIInsertV2 appears to indicate that you can call the API with a simple HTTP post. I would like to avoid the overhead of SOAP. I tried guessing a few delimters to pass the arrInsertValueArray and arrInsertValueArray but I didn't get anywhere. Is this possible?

Re: Trouble deleting records in other table

nsmith_piano — Sun, 29 Sep 2013 23:52:55 GMT

Thanks for checking Jason. Did you hear anything back from the developers?

Trouble deleting records in other table

nsmith_piano — Fri, 20 Sep 2013 19:18:07 GMT

I have a custom table called Events. When I delete an event, I want to delete all the records related to the event in the EventComments table.

I have a grid with events on my custom screen, and the following actions:

1. Show message with a confirmation buttion.

2. Loop through checked items on the grid

3. Delete record from table Event Comment where eventname_recordid = value from row:record id.

When I publish this and run click the button, I get the following error:

Error running the query

Additional Information

Action Sequence Order:3