I find my self hitting the wall, again and again, trying to make a POST call to an API using Insert from URL curl. When I try the code in POSTMAN it works very well, but trying to translate the curl options into Filemaker is where I fail. This is my POSTMAN code:
curl -X POST \
-H 'user: username:passowrd' \
-H 'Content-Type: application/xml' \
-H 'Postman-Token: ff84b952-74c8-f06b-976d-f860d9d66de7' \
-d '<?xml version='\''1.0'\'' encoding='\''UTF-8'\''?><SeguimientoEnviosRequest xmlns:xsi='\''http://www.w3.org/2001/XMLSchema-instance'\'' xsi:noNamespaceSchemaLocation='\''SeguimientoEnviosRequest.xsd'\''><Solicitante>x</Solicitante><Dato>xxxxxxxxxxxxxxxxx</Dato> </SeguimientoEnviosRequest>'
The yellow part is what I should put under "Body" and after in "raw" in POSTMAN and it is just that the one I can not figure out how to put it as a curl option for the Insert from URL... :(. I pass authorisation using username and password, but I get all the time the same error of missing "XML entry template"
Any idea on how to overcome this error? is the XML entry template the headers that this api needs to have them custom?
Thanks a lot!!!
I'm working on a database right now that handles general accounting information for a department of a university. My current layout looks like this:
Where the left section has buttons to take you to the different layouts and look at various different tables, and the middle column is a scrollable portal to look at all of the jobs. On the right hand side for the "employees" section, I was able to fit all of an employee's data in that space, so it worked, but each job has significantly more data associated with it and doesn't fit in that space, so I was wondering if there is a way to make that section scrollable, but looking at the same record (i.e. The job description would be at the top, and then some info on what materials and labor have been billed to that job, and then be able to scroll down and have another section with contact info for employees assigned to that job, etc.). From what I've been looking around at for solutions it looks like this is impossible, but I'm hoping that maybe there's someone out there that's more creative than me! I thought about making the whole layout taller and then somehow locking the left columns into position while scrolling so that they would be fixed in the viewport, but I couldn't find a way to do that. Thanks guys!
Am a bit lost on what (I think) should be a quite simple script:
Field 1 has a value list on layout.
Field 2 is a general text field for typed data entry..
My goal is to use Field 1 to trigger/manage a script which does severla things, but then leaves the mouse/selector inserted into Field 2, for ease of use...
When I select an item in that value list, an OnObjectExit triggered script:
sets a variable from that, then clears that field inserts a calculated value (based on the variable created) in another field. Then it SHOULD "go to Field 2"... as in, after the script is done, the cursor should be inserted into Field 2 with a blinking cursor... My problem is, this isn't working.
the first two parts are working flawlessly - it creates and acts on variables, as it should..
But it refuses to 'go to field' (or "go to object", if i try it that way)..
What's happening instead is this: the script runs, but the selector/mouse jumps on forward to the next object (if that object is in a tab order), or (if NOT in a tab order), it goes nowhere (it operates the script, but dies before setting mouse to the field or object).....
I also tried OnObjectModify and OnObjectSave.... No dice on either.....The mouse simply refuses to "go to field"....
additionally, i tried triggering ANOTHER script (which works on its own) - - simply "go to field 2".. but even that doesn't work..
My guess is that the script (as an OnObjectExit trigger) runs, then FMP assumes that after the script ends, the next object should be selected (rather than ending wherever I told it to end)...
I’m pretty new with using Filemaker, but still I built a solution that fits pretty all my needs (for now…)
I’m still experiencing one big problem with my solution for which I would need help.
Here’s the context : I run a little company. We receive financial reports every quarter.
All quarterly reports ( Excel file or csv file) have the exact same form.
I then created a layout based on the table created when importing the csv that works properly.
My need: as I’m to receive a new financial report on next quarters (Q12018, Q22018, Q32018 etc.), I would like to pull the new data from my Main layout.
Is there a way of having a layout pull the data from the new table (actually whatever table) to be created each time I’ll be importing a new Financial Report without getting rid of the original data (which I would like to keep in place, for obvious reasons)? Let’s say from a pull down?
Thank you very much for your help and don’t hesitate to get back to me if my explanations aren’t clear enough.
I'd get some problems with date formats after installing FMS 15, and I'm trying to solve it by importing to a clone of the original database. But two tables has no layouts and I can't find a way to import these tables without making a layout in the clone or adding a table when importing. The last seems to be the simplest, but how will the relationships behave?
Who Viewed the Topic