@undefined that's correct 🙂

@joseph-benguira

I've tried using Cloudflares pagerule "Cache everything" - but since the headers invalidate cache, Cloudflare will do the same and set pages to "Dynamic" mode.

From cloudflare:
"Whether we actually store the asset and for how long is determined by the Cache-Control headers returned with responses from the origin server"

Using Edge Cache TTL makes it possible, but that disables all cookies....

This means the potential API requests for this site with 400 products and 2x languages would be 2.3M requests in 24 hours....

Can you please change the admin text for cache duration, it's very missleading if it's only for assets and not content (as the text says).

I can confirm that variables in SQL are not supported on Cloud Backend

@wassim Excellent thank you 🙂

@pierre-sulpice yes, this search only on what is visible on screen, if you need to filter in the whole entries of your DB use the filters.

@jbenguira
No, I didn't mean migrate a page from another site, but rather copy a template in Appdrag and add HTML to it (I know this HTML won't be builder-editable).

I tried making a copy in the preview folder and it appeared in the builders menu, seems to work as expected ✌

@Wassim thanks for you answer.

I agree that the file will be tricky to find but I still try to the basic "even hard to find it shouldn't be public when it's related to security", and it's literally for all ma security checks 😕

I thought about the other solution but I'm trying to develop something very easy to maintain for any developers even with a low formation for my clients, your solution itself is great and easy to use, I don't want to complexify it.

I think the third solution I will retain is to create a proxy route that will take care of this common code then call the adequate resource and return the result.

I think having private code outside of a route but still on AppDrag is the only major feature I miss right now !

I haven't said it in a while: Thanks for AppDrag in general, I'm really having a great time on it 🙂

See you soon,
Best regards,

Hi,
Ok I added a fix to handle them even if they're string instead of integers. It will be pushed in production tonight.

Hello @Daniel-Mulroy ,

Dropdown & Dropdown Multi Field Type are only in Cloud DB UI.
To enter content inside you have to create lists and assign a list to the column :

a82b3288-5f99-4444-b370-1941ae3cba44-image.png

a0e59966-4279-43e3-819d-a82c086d36eb-image.png

Then you'll be able to select items from your list
e554ffdb-1db7-4e70-9e97-c269fe7c58c1-image.png

It seems you think linked fields and dropdowns are the same but they aren't.

Linked fields are as their name suggest fields linked to another table Dropdowns are lists you manually create allowing users to select values from it. It can be used only in Cloud DB UI

@Pablo-Garcia

I'm confused by the word VALUE in your query. I am pretty sure that is causing the issue.

If you're coming from a different SQL platform, you should be aware that CloubBackend uses MySQL 5.8 via AWS Aurora, so your queries have to adhere to that syntax.

I think if you simply removed "VALUE" from most of your queries above things might start working 🙂

@Wassim

I'm doing that, but it's limited to 100KB per object string in the JSON.

@Joseph-Benguira suggested that I retrieve the page and parse the tags manually and then return only the HTML as the page, so I guess I'll have no other choice than to do that.

Hi,

I would use an npm package to read the uploaded file :

https://www.npmjs.com/package/csv-parser https://www.npmjs.com/package/csv-reader

And then generate the SQL request to insert it into your database.

@Joseph-Benguira soooorry got it thanks 🙂

@Joseph-Benguira excellent thanks 🙂 and can I upload a gatsby js frontend for it? If yes which option on the dashboard do I choose for that?

Hi,
Yep you can export your database to CSV and import it. There's no direct way or synchronous way to achieve it.

@Joseph-Benguira your plans around cloudgate sound phenomenal ☺️ +1

Hey Franck,
yes it's possible, when you configure your scheduling select "Every-week" in the recurrence type dropdown
you can then indicate the days of the week and hour

dc4a523b-ac9f-4b9b-a1de-1e6aad92c7ae-image.png

Hi Jean,

another option may be to try a csv to sql converter, i.e. https://www.convertcsv.com/csv-to-sql.htm

Then go to your Cloud Backend > Databases > New query

Screenshot 2021-03-17 at 22.27.18.png

The copy the sql code to create the table

Screenshot 2021-03-17 at 22.26.32.png

I've actually built my own tool to create this 'create table' sql code to quickly replicate FileMaker tables in AppDrag 🙂

I do see that when you sync it down, you have a 'config file' (api.json) with the relevant metadata.

Here's a sample:

"appId": "abcd-1234", "funcs": { "/": [ // filepath { "id": 1234, // function ID "name": "myGreatFunction", function Name "description": "", "type": "nodejs12.x", "contentType": "FILE", "method": "PUT", "ram": 128, "timeout": 15, "output": "JSON" }, //etc.

My suggestion is, maybe the fs pull can (either by default or with an arg) write the APIs in the correct folder structure, with the function names.

Then, when uploading, it can match the filenames/paths with the JSON config file in order to upload it back to the server in the right place.

This is a huge difference between something like AppDrag and Netlify or others. I love AppDrag but I'm spending a LOT of time trying to do simple things like sync my code to gitHub or work effectively locally in VS Code without copy/pasting code by hand back and forth.

@Daniel-Mulroy said in Rotating/Changing API Key:

Thanks @Wassim that helps.

Does that mean the environment vars are 'hardcoded' into the version of the script that is published?

more info here :
https://docs.aws.amazon.com/lambda/latest/dg/configuration-envvars.html

You define environment variables on the unpublished version of your function. When you publish a version, the environment variables are locked for that version along with other version-specific configuration.

Thank You Wassim.

https://www.npmjs.com/package/appdrag-cloudbackend

You can JSON.parse(response); and check numberOfAffectedRows.

Can you share a link to support@appdrag.com with the steps to reproduce?

@Wassim said in Is the AppDrag function name (or URL?) available from within an API Function?:

Seems a very good and practical way to do it. You can also manually define it in your API functions while setting sentry up no?

Yes, I could, but I'm looking for reusable / template code I can copy/paste very quickly between functions and/or use in my template library... so I don't want to think about it each time, just want it to work every time 🙂

For reference, here's my final code to get the function name both during testing "Try" in CloudBackend and also when the function is called 'normally':

module.exports.getFunctionInfo = (event, context) => { let fInfo = {}; // Try to extrapolate function info // sometimes the from-url is not available, so wrapping this in a try/catch block try { const httpMethods = ["GET", "POST", "PUT", "DELETE", "PATCH"]; var functionHandle = event.HEADERS['from-url'].split('/').slice(-1)[0]; // Get from URL if it's been called from the web for (let method of httpMethods) { // Get from parameters if it's been called from "Try" method, because above method will not work. Could also ignore errors if running from Try Now as they are likely development errors.... if (event[method] && event[method].APPDRAG_FUNCTION_NAME != null) functionHandle = event[method].APPDRAG_FUNCTION_NAME; } fInfo.functionHandle = functionHandle; } catch (e) { fInfo.functionHandle = ""; } fInfo.functionVersion = context.functionVersion; fInfo.functionName = context.functionName; return fInfo; };

Hello,
Exactly, thanks to you for finding this issue!
This has been corrected, it will be live tomorrow.

Hey, yes you can call it whatever you want as they are just variable names.
You just have to use the same name when using process.env.yourVariable. Your code will use the computed value of it so the name has no impact. (unless a library specifically use inside its code process.env.whateverVariable)

Hey Pierre, please ensure the email sender address configured in your whitelabel settings is validated or else indeed no emails will be sent
Another option is to clear the sender email address field in your whitelabel settings

@Wassim

Super, then I don't need to worry about that ✌

Hey Ugnius,

in the env variable settings, add a new env var, name it "googleJSON" for eg. but you can name it as you want
on the right side, as value, paste the whole text content of the json file you have from google.

var googleJSON = JSON.parse(process.env.googleJSON);

admin.initializeApp({
credential: admin.credential.cert({
projectId: googleJSON.project_id,
clientEmail: googleJSON.client_email,
privateKey: googleJSON.private_key
}),
databaseURL: "https://<DATABASE_NAME>.firebaseio.com"
});

Just a small thing, whenever you can you should avoid Google!
Google deprecates API and services every week and providing nearly zero warning to "customers", in fact they have no respect at all for developers using their services and it's nearly impossible to talk with someone there. So if you want your service to be down in the next 6 months because it's deprecated without any notice ... sure go with google 🙂

@Wassim Wonderful, thanks!

I have been wishing for this. @Wassim Would it be possible to choose to use an integer or a UUID for the default 'id' / index column?

Hi Marc, wish you're fine!

On Visual SQL Select if you look at the documentation there are those parameters to determine the page size and page number to avoid people to fetch too many rows when it's not needed.

125c878f-5b75-4c49-a730-f0d0f1d4c43a-image.png

If you really need to fetch more results:

Set the pageSize to a higher value Use Raw SQL Select

Hey Gerson,

I can confirm that all the data on AppDrag is stored only in EU (AWS EU-WEST-1, in Dublin, Ireland)

That was so obvious... I don't know why I was going that far.... thanks a lot !

Hello,

Sorry for the late reply, it works like a charm, thanks 🙂

See you soon,

@Daniel-Mulroy thank you so much for this🤩...hope it didnt disturb your work flow 🙈you're in luck, am on windows so once I get up and running I'll let you know 🙂