To build an AND clause, you just keep adding parameters. Note you can only do a look up against EQUALS, not greater than like in your example. If you need to do that, you should use ExecuteFilter with a DataFilter
So, it would be something like:
LookupOrderedRows("Cars",4, "name1", @val1,"name2", @val2,"name3", @val3)
You can perform GET and POST methods to perform REST API calls.
http://help.exacttarget.com/en/documentation/exacttarget/content/ampscript/ampscript_syntax_guide/http_ampscript_functions/
Create your AMPscript using the functions below and place them in the
content areas of landing pages and email messages. For example, you
can use the URLEncode() function to encode spaces or non-alphanumeric
characters contained in a URL for use by your subscribers.
HTTPGet("http://www.example.com")
There are also methods to update headers if that's needed, as well. Passing data may also cause some difficulty and the issue is if the result is JSON, there isn't a great way to handle it.
Depending on the situation, you would be better off with SSJS, but if this happening during a send, it's best to get the data prior to sending anything. If it's on a landing page - you would be ok.
https://help.exacttarget.com/en-US/documentation/exacttarget/content/server_side_javascript/server_side_javascript_syntax_guide/http_server_side_javascript_functions/
You can use the HTTP server-side JavaScript functions to perform HTTP
GET and HTTP POST actions and use that information as part of your
interactions with the ExactTarget application.
var url = 'http://www.example.com';
var headerNames = ["MyTestHeader1", "MyTestHeader2"];
var headerValues = ["MyTestValue1", "MyTestValue2"];
var response = HTTP.Get(url, headerNames, headerValues);
Best Answer
A profile attribute could be used to hold the value for the location of the unique location for that subscribers PDF. This profile attribute would need to be created in the UI in the Profile Management section. Lets assume the field is called PDFLocation. The body of the email would have to contain a reference to the AttachFile function referencing that attribute:
Then in the JSON body for ContactAttributes, pass the value: